DBA Data[Home] [Help]

APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on PER_SPINAL_POINT_STEPS_F

Line 1559: from per_spinal_point_steps_f psp,

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,
1561: per_spinal_point_steps_f psp2
1562: where psp.sequence>= psp2.sequence
1563: and pspp.step_id=psp.step_id

Line 1561: per_spinal_point_steps_f psp2

1557: ) is
1558: select count(*)
1559: from per_spinal_point_steps_f psp,
1560: per_spinal_point_placements_f pspp,
1561: per_spinal_point_steps_f psp2
1562: where psp.sequence>= psp2.sequence
1563: and pspp.step_id=psp.step_id
1564: and pspp.assignment_id=p_assignment_id
1565: and psp.grade_spine_id=psp2.grade_spine_id