DBA Data[Home] [Help]

APPS.PQP_NL_EXT_FUNCTIONS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 782: FROM pay_assignment_actions paa

778:
779: --cursor to fetch the greatest date earned for the assignment
780: CURSOR c_get_max_date_earned IS
781: SELECT max(ppa.date_earned)
782: FROM pay_assignment_actions paa
783: ,pay_payroll_actions ppa
784: WHERE paa.assignment_id = p_assignment_id
785: AND ppa.payroll_action_id = paa.payroll_action_id;
786:

Line 949: FROM pay_assignment_actions paa

945:
946: --cursor to fetch the greatest date earned for the assignment
947: CURSOR c_get_max_date_earned IS
948: SELECT max(ppa.date_earned)
949: FROM pay_assignment_actions paa
950: ,pay_payroll_actions ppa
951: WHERE paa.assignment_id = p_assignment_id
952: AND ppa.payroll_action_id = paa.payroll_action_id;
953: