DBA Data[Home] [Help]

APPS.PQH_SS_PRINT dependencies on PER_COLLECTIVE_AGREEMENTS

Line 836: FROM per_collective_agreements

832: RETURN VARCHAR2 IS
833: --
834: CURSOR csr_collective_agreement(p_collective_agreement_id NUMBER) IS
835: SELECT name
836: FROM per_collective_agreements
837: WHERE collective_agreement_id = p_collective_agreement_id;
838: --
839: l_name per_collective_agreements.name%TYPE := null;
840: --

Line 839: l_name per_collective_agreements.name%TYPE := null;

835: SELECT name
836: FROM per_collective_agreements
837: WHERE collective_agreement_id = p_collective_agreement_id;
838: --
839: l_name per_collective_agreements.name%TYPE := null;
840: --
841: BEGIN
842: --
843: IF p_collective_agreement_id IS NOT NULL THEN