eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_CBS_FILE dependencies on PER_SPINAL_POINT_STEPS_F

Line 796: Select max(sequence) from per_spinal_point_steps_f psps

792: And pg.business_group_id = p_business_group_id;
793:
794: -- Cursor to get the ceiling
795: Cursor csr_get_ceiling(p_grade_id number,p_business_group_id number,p_reporting_date date) is
796: Select max(sequence) from per_spinal_point_steps_f psps
797: Where psps.grade_spine_id = (select grade_spine_id from per_grade_spines_f pgs
798: Where grade_id = p_grade_id
799: And p_reporting_date between pgs.effective_start_date and pgs.effective_end_date
800: and pgs.business_Group_id = p_businesS_group_id)

Line 808: from per_spinal_point_steps_f psps

804: -- Cursor to get the salary sequence
805: Cursor csr_get_salary_sequence (p_grade_id number, p_business_group_id number,
806: p_assignment_id number,p_reporting_date date) is
807: Select sequence
808: from per_spinal_point_steps_f psps
809: Where psps.grade_spine_id = (select grade_spine_id from per_grade_spines_f pgs
810: Where grade_id = p_grade_id
811: And p_reporting_date between pgs.effective_start_date and pgs.effective_end_date
812: and pgs.business_Group_id = p_business_group_id)