SELECT
    pp.parent_pid
FROM
    pip_pip pp
WHERE
    NOT EXISTS( SELECT
            pp2.child_pid
        FROM
            pip_pip pp2
        WHERE
            pp.parent_pid = pp2.child_pid)