APPS.PAY_GB_RTI_FPS_OUTPUT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 619: from pay_assignment_actions paa_arch,

615: (c_mag_payroll_actid number,
616: c_mag_asg_action_id number,
617: c_arch_pay_action_id number) is
618: select paa_arch.assignment_action_id
619: from pay_assignment_actions paa_arch,
620: pay_assignment_actions paa_mag,
621: pay_action_information pai
622: where paa_mag.payroll_action_id = c_mag_payroll_actid
623: and paa_mag.assignment_action_id = c_mag_asg_action_id

Line 620: pay_assignment_actions paa_mag,

616: c_mag_asg_action_id number,
617: c_arch_pay_action_id number) is
618: select paa_arch.assignment_action_id
619: from pay_assignment_actions paa_arch,
620: pay_assignment_actions paa_mag,
621: pay_action_information pai
622: where paa_mag.payroll_action_id = c_mag_payroll_actid
623: and paa_mag.assignment_action_id = c_mag_asg_action_id
624: and paa_arch.payroll_action_id = c_arch_pay_action_id

Line 639: from pay_assignment_actions paa_current,

635: c_arch_asg_action_id number) is
636:
637: select distinct paa_other.assignment_id,
638: paa_other.assignment_action_id
639: from pay_assignment_actions paa_current,
640: per_all_assignments_f paaf_current,
641: pay_assignment_actions paa_other,
642: per_all_assignments_f paaf_other
643: where paa_current.payroll_action_id = c_arch_pay_action_id

Line 641: pay_assignment_actions paa_other,

637: select distinct paa_other.assignment_id,
638: paa_other.assignment_action_id
639: from pay_assignment_actions paa_current,
640: per_all_assignments_f paaf_current,
641: pay_assignment_actions paa_other,
642: per_all_assignments_f paaf_other
643: where paa_current.payroll_action_id = c_arch_pay_action_id
644: and paa_current.assignment_action_id = c_arch_asg_action_id
645: and paaf_current.assignment_id = paa_current.assignment_id

Line 1619: from pay_assignment_actions paa,

1615:
1616:
1617: cursor csr_asg (c_arch_payroll_action_id number) is
1618: select distinct paa.assignment_id
1619: from pay_assignment_actions paa,
1620: pay_action_information pai,
1621: per_all_assignments_f paaf
1622: where paa.payroll_action_id = c_arch_payroll_action_id
1623: and pai.action_context_id = paa.assignment_action_id

Line 1650: select pay_assignment_actions_s.nextval

1646: hr_utility.set_location('Assignment ID :' || lv_assignment_id,56);
1647:
1648: -- Create one assignment action for every assignment
1649: hr_utility.set_location('Archiving for assignment_id '||lv_assignment_id, 57);
1650: select pay_assignment_actions_s.nextval
1651: into lockingactid
1652: from dual;
1653:
1654: -- Insert assignment into pay_assignment_actions

Line 1654: -- Insert assignment into pay_assignment_actions

1650: select pay_assignment_actions_s.nextval
1651: into lockingactid
1652: from dual;
1653:
1654: -- Insert assignment into pay_assignment_actions
1655: hr_nonrun_asact.insact
1656: (
1657: lockingactid,
1658: lv_assignment_id,