APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 533: l_assignment_id per_all_assignments_f.assignment_id%type;

529: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
530: ,p_calculation_date in date
531: ) is
532: --
533: l_assignment_id per_all_assignments_f.assignment_id%type;
534: --
535: l_balance number; -- Bug: 3991308
536: l_action_info_id pay_action_information.action_information_id%type;
537: l_ovn pay_action_information.object_version_number%type;

Line 1382: from per_all_assignments_f

1378: /* Bug 5504354 c_get_bus_id */
1379: cursor c_get_bus_id ( p_assignment_id pay_assignment_actions.assignment_id%type
1380: ,p_effective_date date ) is
1381: select distinct business_group_id
1382: from per_all_assignments_f
1383: where assignment_id=p_assignment_id
1384: and p_effective_date between effective_start_date and effective_end_date;
1385:
1386:

Line 1391: p_business_group_id per_all_assignments_f.business_group_id%type

1387: /* Bug 5504354 - Cursor c_grade_step added to get the grade step of an assignment */
1388:
1389: cursor c_grade_step(p_assignment_id pay_assignment_actions.assignment_id%type
1390: ,p_effective_date pay_payroll_actions.effective_date%type,
1391: p_business_group_id per_all_assignments_f.business_group_id%type
1392: ) is
1393: select count(*)
1394: from per_spinal_point_steps_f psp,
1395: per_spinal_point_placements_f pspp,

Line 1411: l_business_group_id per_all_assignments_f.business_group_id%type;

1407: psp2.effective_start_date and psp2.effective_end_date
1408: and p_effective_date between
1409: pspp.effective_start_date and pspp.effective_end_date;
1410:
1411: l_business_group_id per_all_assignments_f.business_group_id%type;
1412:
1413: l_step varchar2(10); /* Bug 5504354 */
1414:
1415: l_pay_advice_date date ; /* Bug 5504354 */