DBA Data[Home] [Help]

APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on PER_SPINAL_POINT_STEPS_F

Line 1394: from per_spinal_point_steps_f psp,

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,
1396: per_spinal_point_steps_f psp2
1397: where psp.sequence>= psp2.sequence
1398: and pspp.step_id=psp.step_id

Line 1396: per_spinal_point_steps_f psp2

1392: ) is
1393: select count(*)
1394: from per_spinal_point_steps_f psp,
1395: per_spinal_point_placements_f pspp,
1396: per_spinal_point_steps_f psp2
1397: where psp.sequence>= psp2.sequence
1398: and pspp.step_id=psp.step_id
1399: and pspp.assignment_id=p_assignment_id
1400: and psp.grade_spine_id=psp2.grade_spine_id