APPS.PAY_CA_YEER_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 3303: from pay_assignment_actions paa,

3299: select paa.assignment_action_id,
3300: paa.assignment_id,
3301: paa.serial_number person_id,
3302: paa.action_status
3303: from pay_assignment_actions paa,
3304: pay_payroll_actions ppa,
3305: per_all_people_f ppf
3306: where paa.payroll_action_id = cp_pactid
3307: and ppa.payroll_action_id = paa.payroll_action_id

Line 3313: from pay_assignment_actions paa_amend,

3309: and ppa.effective_date between ppf.effective_start_date /*10316246 sbachu*/
3310: and ppf.effective_end_date
3311: and not exists
3312: (select 1
3313: from pay_assignment_actions paa_amend,
3314: pay_payroll_actions ppa_amend
3315: where paa_amend.payroll_action_id > cp_pactid
3316: and paa.serial_number = paa_amend.serial_number
3317: and ppa_amend.payroll_action_id = paa_amend.payroll_action_id

Line 3444: from pay_assignment_actions paa,

3440:
3441: /* Bug 6837510 */
3442: cursor cur_get_location(cp_asgact_id number) is
3443: select paf.LOCATION_ID
3444: from pay_assignment_actions paa,
3445: per_assignments_f paf
3446: where paa.assignment_action_id = cp_asgact_id
3447: and paf.assignment_id = paa.assignment_id;
3448:

Line 3454: ,pay_assignment_actions paa_arch

3450: cursor c_further_codes(cp_asgact_id number) is
3451: select pai_emp.ACTION_INFORMATION4 code, pai_emp.ACTION_INFORMATION5 value,
3452: initcap(rtrim(ltrim(replace(replace(replace(pai_emp.ACTION_INFORMATION4,'RL2_'),'AMOUNT_'),'_',' ')))) short_name
3453: FROM pay_action_information pai_emp
3454: ,pay_assignment_actions paa_arch
3455: ,pay_payroll_actions ppa_arch
3456: where pai_emp.action_context_id=cp_asgact_id
3457: AND pai_emp.action_context_id = paa_arch.assignment_action_id
3458: AND pai_emp.action_information_category = 'CAEOY RL2 FURTHER INFO'

Line 3857: from pay_assignment_actions paa,

3853: paa.assignment_id,
3854: paa.serial_number person_id,
3855: paa.action_status,
3856: ppf.last_name,ppf.first_name,ppf.middle_names
3857: from pay_assignment_actions paa,
3858: pay_payroll_actions ppa,
3859: per_all_people_f ppf
3860: where paa.payroll_action_id = cp_pactid
3861: and ppa.payroll_action_id = paa.payroll_action_id

Line 3867: from pay_assignment_actions paa_amend,

3863: and ppa.effective_date between ppf.effective_start_date
3864: and ppf.effective_end_date
3865: and not exists
3866: (select 1
3867: from pay_assignment_actions paa_amend,
3868: pay_payroll_actions ppa_amend
3869: where paa_amend.payroll_action_id > cp_pactid
3870: and paa.serial_number = paa_amend.serial_number
3871: and ppa_amend.payroll_action_id = paa_amend.payroll_action_id