DBA Data[Home] [Help]

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 942: PER_ALL_ASSIGNMENTS_F PAAF

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
946: AND P_DATE_EARNED BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE