DBA Data[Home] [Help]

APPS.PQP_NL_EXT_FUNCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 783: ,pay_payroll_actions ppa

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:
787: --cursor to fetch the minimum start date of the assignment

Line 950: ,pay_payroll_actions ppa

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:
954: --cursor to fetch the minimum start date of the assignment