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 126: from per_spinal_point_placements_f spp1,

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

Line 127: per_spinal_point_placements_f spp,

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

Line 175: from per_spinal_point_placements_f spp1,

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

Line 176: per_spinal_point_placements_f spp,

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

Line 246: from per_spinal_point_placements_f spp

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

Line 255: from per_spinal_point_placements_f spp,

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

Line 267: from per_spinal_point_placements_f spp,

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

Line 279: from per_spinal_point_placements_f spp,

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

Line 302: from per_spinal_point_placements_f spp,

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

Line 846: from per_spinal_point_placements_f

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

Line 888: per_spinal_point_placements_f spp

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

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

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

Line 1410: LC_Object_Version_Number per_spinal_point_placements_f.object_version_number%TYPE;

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

Line 1411: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;

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

Line 1482: per_spinal_point_placements_f spp

1478: per_spinal_points psp1,
1479: per_spinal_point_steps_f sps1,
1480: per_spinal_points psp,
1481: per_spinal_point_steps_f sps,
1482: per_spinal_point_placements_f spp
1483: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID
1484: OR
1485: (spp.parent_spine_id is not null
1486: and spp.parent_spine_id = P_Parent_Spine_ID))

Line 1584: per_spinal_point_placements_f spp

1580: per_spinal_points psp1,
1581: per_spinal_point_steps_f sps1,
1582: per_spinal_points psp,
1583: per_spinal_point_steps_f sps,
1584: per_spinal_point_placements_f spp
1585: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID
1586: OR
1587: (spp.parent_spine_id is not null
1588: and spp.parent_spine_id = P_Parent_Spine_ID))

Line 1741: per_spinal_point_placements_f spp

1737: paa.payroll_id
1738: from per_all_people_f pap,
1739: per_periods_of_service pos,
1740: per_all_assignments_f paa,
1741: per_spinal_point_placements_f spp
1742: where spp.assignment_id = paa.assignment_id
1743: and paa.person_id = pap.person_id
1744: and pos.person_id = pap.person_id
1745: and spp.business_group_id = p_business_group_id