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.HRSPINE dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 128: from per_spinal_point_placements_f spp1,

124: ,p_grade_rate in number) return varchar2 as
125:
126: Cursor csr_old_spinal_point is
127: select substr(psp1.spinal_point,1,20)
128: from per_spinal_point_placements_f spp1,
129: per_spinal_point_placements_f spp,
130: per_spinal_points psp1,
131: per_spinal_point_steps_f sps1,
132: per_spinal_point_steps_f sps2

Line 129: per_spinal_point_placements_f spp,

125:
126: Cursor csr_old_spinal_point is
127: select substr(psp1.spinal_point,1,20)
128: from per_spinal_point_placements_f spp1,
129: per_spinal_point_placements_f spp,
130: per_spinal_points psp1,
131: per_spinal_point_steps_f sps1,
132: per_spinal_point_steps_f sps2
133: --pay_grade_rules_f pgr2

Line 177: from per_spinal_point_placements_f spp1,

173: ,p_grade_rate in number) return number as
174:
175: Cursor csr_old_spinal_value is
176: select pgr2.value
177: from per_spinal_point_placements_f spp1,
178: per_spinal_point_placements_f spp,
179: per_spinal_points psp1,
180: per_spinal_point_steps_f sps1,
181: pay_grade_rules_f pgr2,

Line 178: per_spinal_point_placements_f spp,

174:
175: Cursor csr_old_spinal_value is
176: select pgr2.value
177: from per_spinal_point_placements_f spp1,
178: per_spinal_point_placements_f spp,
179: per_spinal_points psp1,
180: per_spinal_point_steps_f sps1,
181: pay_grade_rules_f pgr2,
182: per_spinal_point_steps_f sps2

Line 248: from per_spinal_point_placements_f spp

244: /* *** First Ever SPP Record Catch *** */
245:
246: Cursor csr_increment1 is
247: select spp.placement_id
248: from per_spinal_point_placements_f spp
249: where spp.object_version_number = 1
250: and spp.placement_id = p_placement_id
251: and spp.effective_start_date = p_effective_start_date;
252:

Line 257: from per_spinal_point_placements_f spp,

253: /* *** No step update in record, so no grade increment */
254:
255: Cursor csr_increment2 is
256: select spp.placement_id
257: from per_spinal_point_placements_f spp,
258: per_spinal_point_steps_f sps
259: where spp.step_id = p_step_id
260: and spp.placement_id = p_placement_id
261: and spp.effective_end_date = p_effective_start_date -1

Line 269: from per_spinal_point_placements_f spp,

265: /* *** Step was auto created when grade scale changed on assignment form *** */
266:
267: Cursor csr_increment3 is
268: select spp.placement_id
269: from per_spinal_point_placements_f spp,
270: per_spinal_point_steps sps
271: where spp.placement_id = p_placement_id
272: and spp.effective_start_date = p_effective_start_date
273: and sps.grade_spine_id <> p_grade_spine_id

Line 281: from per_spinal_point_placements_f spp,

277: /* *** First Spinal Point Of Grade Scale *** */
278:
279: Cursor csr_increment4 is
280: select spp.placement_id
281: from per_spinal_point_placements_f spp,
282: per_spinal_point_steps_f sps,
283: per_spinal_points psp
284: where spp.placement_id = p_placement_id
285: and spp.effective_start_date = p_effective_start_date

Line 304: from per_spinal_point_placements_f spp,

300: -- have not been found by any of the previous cursors.
301:
302: Cursor csr_all_placements is
303: select distinct spp.placement_id
304: from per_spinal_point_placements_f spp,
305: per_spinal_point_steps_f sps
306: where spp.placement_id = p_placement_id
307: and spp.effective_start_date = p_effective_start_date
308: and spp.step_id = sps.step_id

Line 848: from per_spinal_point_placements_f

844: -- ------------------------------------------------------------------
845: BEGIN
846: select max(effective_end_date)
847: into l_max_end_date
848: from per_spinal_point_placements_f
849: where placement_id = p_placement_id;
850: EXCEPTION
851: WHEN NO_DATA_FOUND
852: THEN

Line 890: per_spinal_point_placements_f spp

886: select nvl(sps.sequence,-99),nvl(sps.grade_spine_id,-99)
887: into l_future_sequence_id,
888: l_future_grade_spine_id
889: from per_spinal_point_steps_f sps,
890: per_spinal_point_placements_f spp
891: where spp.effective_start_date = p_end_date + 1
892: and spp.placement_id = p_placement_id
893: and spp.step_id = sps.step_id;
894: EXCEPTION

Line 1408: -- Parameters added when api created for dml on per_spinal_point_placements_f

1404: LC_Increment_Number number; -- increment number for assignment
1405: LC_Effective_Start_Date date;
1406: --
1407: --
1408: -- Parameters added when api created for dml on per_spinal_point_placements_f
1409: --
1410: l_datetrack_mode varchar2(30) := 'UPDATE_CHANGE_INSERT';
1411: l_reason varchar2(30) := 'AI';
1412: LC_Object_Version_Number per_spinal_point_placements_f.object_version_number%TYPE;

Line 1412: LC_Object_Version_Number per_spinal_point_placements_f.object_version_number%TYPE;

1408: -- Parameters added when api created for dml on per_spinal_point_placements_f
1409: --
1410: l_datetrack_mode varchar2(30) := 'UPDATE_CHANGE_INSERT';
1411: l_reason varchar2(30) := 'AI';
1412: LC_Object_Version_Number per_spinal_point_placements_f.object_version_number%TYPE;
1413: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
1414: l_grade_spine_id per_grade_spines_f.grade_spine_id%TYPE;
1415: l_update varchar2(2);
1416: l_update2 varchar2(2);

Line 1413: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;

1409: --
1410: l_datetrack_mode varchar2(30) := 'UPDATE_CHANGE_INSERT';
1411: l_reason varchar2(30) := 'AI';
1412: LC_Object_Version_Number per_spinal_point_placements_f.object_version_number%TYPE;
1413: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
1414: l_grade_spine_id per_grade_spines_f.grade_spine_id%TYPE;
1415: l_update varchar2(2);
1416: l_update2 varchar2(2);
1417: l_exception_report1 varchar2(2);

Line 1484: per_spinal_point_placements_f spp,

1480: per_spinal_points psp1,
1481: per_spinal_point_steps_f sps1,
1482: per_spinal_points psp,
1483: per_spinal_point_steps_f sps,
1484: per_spinal_point_placements_f spp,
1485: per_periods_of_service pps --12727056
1486: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID
1487: OR
1488: (spp.parent_spine_id is not null

Line 1591: per_spinal_point_placements_f spp

1587: per_spinal_points psp1,
1588: per_spinal_point_steps_f sps1,
1589: per_spinal_points psp,
1590: per_spinal_point_steps_f sps,
1591: per_spinal_point_placements_f spp
1592: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID
1593: OR
1594: (spp.parent_spine_id is not null
1595: and spp.parent_spine_id = P_Parent_Spine_ID))

Line 1748: per_spinal_point_placements_f spp

1744: paa.payroll_id
1745: from per_all_people_f pap,
1746: per_periods_of_service pos,
1747: per_all_assignments_f paa,
1748: per_spinal_point_placements_f spp
1749: where spp.assignment_id = paa.assignment_id
1750: and paa.person_id = pap.person_id
1751: and pos.person_id = pap.person_id
1752: and spp.business_group_id = p_business_group_id