APPS.PAY_GB_RTI_OUTPUT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 585: from pay_assignment_actions paa_arch,

581: (c_mag_payroll_actid number,
582: c_mag_asg_action_id number,
583: c_arch_pay_action_id number) is
584: select paa_arch.assignment_action_id
585: from pay_assignment_actions paa_arch,
586: pay_assignment_actions paa_mag,
587: pay_action_information pai
588: where paa_mag.payroll_action_id = c_mag_payroll_actid
589: and paa_mag.assignment_action_id = c_mag_asg_action_id

Line 586: pay_assignment_actions paa_mag,

582: c_mag_asg_action_id number,
583: c_arch_pay_action_id number) is
584: select paa_arch.assignment_action_id
585: from pay_assignment_actions paa_arch,
586: pay_assignment_actions paa_mag,
587: pay_action_information pai
588: where paa_mag.payroll_action_id = c_mag_payroll_actid
589: and paa_mag.assignment_action_id = c_mag_asg_action_id
590: and paa_arch.payroll_action_id = c_arch_pay_action_id

Line 605: from pay_assignment_actions paa_current,

601: c_arch_asg_action_id number) is
602:
603: select distinct paa_other.assignment_id,
604: paa_other.assignment_action_id
605: from pay_assignment_actions paa_current,
606: per_all_assignments_f paaf_current,
607: pay_assignment_actions paa_other,
608: per_all_assignments_f paaf_other
609: where paa_current.payroll_action_id = c_arch_pay_action_id

Line 607: pay_assignment_actions paa_other,

603: select distinct paa_other.assignment_id,
604: paa_other.assignment_action_id
605: from pay_assignment_actions paa_current,
606: per_all_assignments_f paaf_current,
607: pay_assignment_actions paa_other,
608: per_all_assignments_f paaf_other
609: where paa_current.payroll_action_id = c_arch_pay_action_id
610: and paa_current.assignment_action_id = c_arch_asg_action_id
611: and paaf_current.assignment_id = paa_current.assignment_id

Line 967: from pay_assignment_actions paa_arch,

963: (c_mag_payroll_actid number,
964: c_mag_asg_action_id number,
965: c_arch_pay_action_id number) is
966: select paa_arch.assignment_action_id
967: from pay_assignment_actions paa_arch,
968: pay_assignment_actions paa_mag,
969: pay_action_information pai
970: where paa_mag.payroll_action_id = c_mag_payroll_actid
971: and paa_mag.assignment_action_id = c_mag_asg_action_id

Line 968: pay_assignment_actions paa_mag,

964: c_mag_asg_action_id number,
965: c_arch_pay_action_id number) is
966: select paa_arch.assignment_action_id
967: from pay_assignment_actions paa_arch,
968: pay_assignment_actions paa_mag,
969: pay_action_information pai
970: where paa_mag.payroll_action_id = c_mag_payroll_actid
971: and paa_mag.assignment_action_id = c_mag_asg_action_id
972: and paa_arch.payroll_action_id = c_arch_pay_action_id

Line 1142: from pay_assignment_actions paa,

1138:
1139:
1140: cursor csr_asg (c_arch_payroll_action_id number) is
1141: select distinct paa.assignment_id
1142: from pay_assignment_actions paa,
1143: pay_action_information pai,
1144: per_all_assignments_f paaf
1145: where paa.payroll_action_id = c_arch_payroll_action_id
1146: and pai.action_context_id = paa.assignment_action_id

Line 1179: select pay_assignment_actions_s.nextval

1175: hr_utility.set_location('Assignment ID :' || lv_assignment_id,56);
1176:
1177: -- Create one assignment action for every assignment
1178: hr_utility.set_location('Archiving for assignment_id '||lv_assignment_id, 57);
1179: select pay_assignment_actions_s.nextval
1180: into lockingactid
1181: from dual;
1182:
1183: -- Insert assignment into pay_assignment_actions

Line 1183: -- Insert assignment into pay_assignment_actions

1179: select pay_assignment_actions_s.nextval
1180: into lockingactid
1181: from dual;
1182:
1183: -- Insert assignment into pay_assignment_actions
1184: hr_nonrun_asact.insact
1185: (
1186: lockingactid,
1187: lv_assignment_id,