APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PER_SPINAL_POINT_STEPS

Line 367: FROM per_spinal_point_steps

363: WHERE session_id = USERENV('sessionid');
364:
365: Cursor C_grade_spine is
366: SELECT grade_spine_id
367: FROM per_spinal_point_steps
368: WHERE step_id = l_step_id;
369:
370: Cursor C_Pay_Grade is
371: SELECT effective_start_date,effective_end_date,

Line 580: per_spinal_point_steps_pkg.pop_flds(l_grade_step,

576: Loop
577: l_session_date := C_session_rec.effective_date;
578: End Loop;
579:
580: per_spinal_point_steps_pkg.pop_flds(l_grade_step,
581: l_session_date,
582: l_grade_or_spinal_point_id,
583: l_grade_spine_id);
584:

Line 1058: FROM PER_GRADE_SPINES pgs,PER_SPINAL_POINT_STEPS psp

1054: ORDER BY grade_rule_id;
1055: --
1056: Cursor Cpay is
1057: SELECT pgs.grade_id,pgs.grade_spine_id,psp.step_id,psp.sequence
1058: FROM PER_GRADE_SPINES pgs,PER_SPINAL_POINT_STEPS psp
1059: WHERE pgs.parent_spine_id = l_parent_spine_id
1060: AND pgs.business_group_id = p_business_group_id
1061: AND psp.business_group_id = p_business_group_id
1062: AND pgs.grade_spine_id = psp.grade_spine_id

Line 1328: per_spinal_point_steps_pkg.pop_flds(l_grade_step,

1324: Loop
1325: l_session_date := C_session_rec.effective_date;
1326: End Loop;
1327:
1328: per_spinal_point_steps_pkg.pop_flds(l_grade_step,
1329: l_session_date,
1330: salary_rec.grade_or_spinal_point_id,
1331: Grade_rec.grade_spine_id);
1332:

Line 1758: FROM per_spinal_pt_placements_v psp, per_spinal_point_steps pss

1754:
1755: Cursor C_grade_spine is
1756: SELECT pss.grade_spine_id,pss.spinal_point_id,
1757: pss.sequence
1758: FROM per_spinal_pt_placements_v psp, per_spinal_point_steps pss
1759: WHERE psp.step_id = pss.step_id
1760: AND psp.assignment_id = l_assignment_id;
1761:
1762: Cursor C_session is

Line 1993: per_spinal_point_steps_pkg.pop_flds(l_grade_step,

1989: Loop
1990: l_session_date := C_session_rec.effective_date;
1991: End Loop;
1992:
1993: per_spinal_point_steps_pkg.pop_flds(l_grade_step,
1994: l_session_date,
1995: l_spinal_point_id,
1996: l_grade_spine_id);
1997: