APPS.PAY_CA_YEER_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 2936: from pay_assignment_actions paa,

2932: select paa.assignment_action_id,
2933: paa.assignment_id,
2934: paa.serial_number person_id,
2935: paa.action_status
2936: from pay_assignment_actions paa,
2937: pay_payroll_actions ppa,
2938: per_all_people_f ppf
2939: where paa.payroll_action_id = cp_pactid
2940: and ppa.payroll_action_id = paa.payroll_action_id

Line 2944: from pay_assignment_actions paa_amend,

2940: and ppa.payroll_action_id = paa.payroll_action_id
2941: and ppa.business_group_id = fp_b_g_id
2942: and not exists
2943: (select 1
2944: from pay_assignment_actions paa_amend,
2945: pay_payroll_actions ppa_amend
2946: where paa_amend.payroll_action_id > cp_pactid
2947: and paa.serial_number = paa_amend.serial_number
2948: and ppa_amend.payroll_action_id = paa_amend.payroll_action_id

Line 3394: from pay_assignment_actions paa,

3390: paa.assignment_id,
3391: paa.serial_number person_id,
3392: paa.action_status,
3393: ppf.last_name,ppf.first_name,ppf.middle_names
3394: from pay_assignment_actions paa,
3395: pay_payroll_actions ppa,
3396: per_all_people_f ppf
3397: where paa.payroll_action_id = cp_pactid
3398: and ppa.payroll_action_id = paa.payroll_action_id

Line 3402: from pay_assignment_actions paa_amend,

3398: and ppa.payroll_action_id = paa.payroll_action_id
3399: and ppa.business_group_id = fp_b_g_id
3400: and not exists
3401: (select 1
3402: from pay_assignment_actions paa_amend,
3403: pay_payroll_actions ppa_amend
3404: where paa_amend.payroll_action_id > cp_pactid
3405: and paa.serial_number = paa_amend.serial_number
3406: and ppa_amend.payroll_action_id = paa_amend.payroll_action_id