APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PER_COLLECTIVE_AGREEMENTS

Line 941: PER_COLLECTIVE_AGREEMENTS PCG,

937:
938: CURSOR CSR_COLL_AGR_NO (P_ASG_ID NUMBER , P_DATE_EARNED DATE, P_BG_ID NUMBER) IS
939: SELECT NAME
940: FROM
941: PER_COLLECTIVE_AGREEMENTS PCG,
942: PER_ALL_ASSIGNMENTS_F PAAF
943: WHERE
944: PAAF.COLLECTIVE_AGREEMENT_ID = PCG.COLLECTIVE_AGREEMENT_ID
945: AND PAAF.BUSINESS_GROUP_ID = PCG.BUSINESS_GROUP_ID

Line 951: l_name PER_COLLECTIVE_AGREEMENTS.NAME%TYPE;

947: AND P_DATE_EARNED BETWEEN PCG.START_DATE AND NVL(PCG.END_DATE, TO_DATE('31-12-4712','DD-MM-RRRR'))
948: AND PAAF.ASSIGNMENT_ID = P_ASG_ID
949: AND PAAF.BUSINESS_GROUP_ID = P_BG_ID;
950:
951: l_name PER_COLLECTIVE_AGREEMENTS.NAME%TYPE;
952:
953: BEGIN
954:
955: OPEN CSR_COLL_AGR_NO(p_asg_id, p_date_earned, p_bg_id);