APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 543: l_assignment_id per_all_assignments_f.assignment_id%type;

539: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
540: ,p_calculation_date in date
541: ) is
542: --
543: l_assignment_id per_all_assignments_f.assignment_id%type;
544: --
545: l_balance number; -- Bug: 3991308
546: l_action_info_id pay_action_information.action_information_id%type;
547: l_ovn pay_action_information.object_version_number%type;

Line 1547: from per_all_assignments_f

1543: /* Bug 5504354 c_get_bus_id */
1544: cursor c_get_bus_id ( p_assignment_id pay_assignment_actions.assignment_id%type
1545: ,p_effective_date date ) is
1546: select distinct business_group_id
1547: from per_all_assignments_f
1548: where assignment_id=p_assignment_id
1549: and p_effective_date between effective_start_date and effective_end_date;
1550:
1551:

Line 1556: p_business_group_id per_all_assignments_f.business_group_id%type

1552: /* Bug 5504354 - Cursor c_grade_step added to get the grade step of an assignment */
1553:
1554: cursor c_grade_step(p_assignment_id pay_assignment_actions.assignment_id%type
1555: ,p_effective_date pay_payroll_actions.effective_date%type,
1556: p_business_group_id per_all_assignments_f.business_group_id%type
1557: ) is
1558: select count(*)
1559: from per_spinal_point_steps_f psp,
1560: per_spinal_point_placements_f pspp,

Line 1576: l_business_group_id per_all_assignments_f.business_group_id%type;

1572: psp2.effective_start_date and psp2.effective_end_date
1573: and p_effective_date between
1574: pspp.effective_start_date and pspp.effective_end_date;
1575:
1576: l_business_group_id per_all_assignments_f.business_group_id%type;
1577:
1578: l_step varchar2(10); /* Bug 5504354 */
1579:
1580: l_pay_advice_date date ; /* Bug 5504354 */