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.PQH_GSP_STAGE_TO_HR dependencies on PER_GRADE_SPINES_F

Line 275: from per_grade_spines_f

271: hr_utility.set_location('inside dele grade spine',10);
272: begin
273: select object_version_number,effective_start_date,effective_end_date
274: into l_gs_ovn,l_gs_esd,l_gs_eed
275: from per_grade_spines_f
276: where grade_spine_id = p_grade_spine_id
277: and p_effective_date between effective_start_date and effective_end_date;
278: exception
279: when others then

Line 312: L_Hr_parent_Spine Per_grade_Spines_F.Parent_Spine_Id%TYPE;

308: l_Step_Ovn Per_Spinal_Point_Steps_F.Object_Version_Number%TYPE;
309: l_datetrack_mode Varchar2(30);
310: l_Scale_Delete Varchar2(1) := 'N';
311: l_Effective_Date Date;
312: L_Hr_parent_Spine Per_grade_Spines_F.Parent_Spine_Id%TYPE;
313: l_Hr_grade_Scale_id Per_grade_Spines_F.Grade_Spine_Id%TYPE;
314: L_Esd Date;
315: l_Eed Date;
316: L_ZAP BOOLEAN;

Line 313: l_Hr_grade_Scale_id Per_grade_Spines_F.Grade_Spine_Id%TYPE;

309: l_datetrack_mode Varchar2(30);
310: l_Scale_Delete Varchar2(1) := 'N';
311: l_Effective_Date Date;
312: L_Hr_parent_Spine Per_grade_Spines_F.Parent_Spine_Id%TYPE;
313: l_Hr_grade_Scale_id Per_grade_Spines_F.Grade_Spine_Id%TYPE;
314: L_Esd Date;
315: l_Eed Date;
316: L_ZAP BOOLEAN;
317: L_DELETE BOOLEAN;

Line 361: From Per_Grade_Spines_F

357:
358: Cursor Csr_Hr_Scale (P_Grade_Id in Number) Is
359: Select Parent_Spine_Id , Grade_Spine_Id,
360: Effective_Start_Date, Effective_End_Date
361: From Per_Grade_Spines_F
362: Where Grade_Id = P_grade_Id
363: and P_Effective_Date
364: Between Effective_Start_Date
365: and Effective_End_Date;

Line 414: ,P_BASE_TABLE_NAME => 'PER_GRADE_SPINES_F'

410: End If;
411:
412: Dt_Api.FIND_DT_DEL_MODES
413: (P_EFFECTIVE_DATE => l_Effective_Date
414: ,P_BASE_TABLE_NAME => 'PER_GRADE_SPINES_F'
415: ,P_BASE_KEY_COLUMN => 'GRADE_SPINE_ID'
416: ,P_BASE_KEY_VALUE => l_Hr_grade_Scale_id
417: ,P_ZAP => L_ZAP
418: ,P_DELETE => L_DELETE

Line 1503: from per_grade_spines_f

1499: begin
1500: begin
1501: select grade_spine_id,parent_spine_id
1502: into l_grade_spine_id,l_parent_spine_id
1503: from per_grade_spines_f
1504: where grade_id = p_grade_id
1505: and p_effective_date between effective_start_date and effective_end_date;
1506: hr_utility.set_location('grade_spine id is '||l_grade_spine_id,35);
1507: exception

Line 1605: from per_grade_spines_f

1601: -- If the payscale linked to grade is changed create grade spine as of effective date
1602: begin
1603: select grade_id
1604: into l_grade_id
1605: from per_grade_spines_f
1606: where grade_id = l_grade_id
1607: and rownum < 2 ;
1608: l_grd_effstdt := p_effective_date;
1609: exception

Line 1647: (p_table_name => 'PER_GRADE_SPINES_F',

1643: hr_utility.set_location('grd_spine exists,ceiling step updated',10);
1644: begin
1645: hr_utility.set_location('going for upd',30);
1646: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1647: (p_table_name => 'PER_GRADE_SPINES_F',
1648: p_key_column_name => 'GRADE_SPINE_ID',
1649: p_key_column_value => l_grade_spine_id,
1650: p_effective_date => p_effective_date);
1651: hr_utility.set_location(' l_db_ovn is '||l_db_ovn,30);

Line 1662: (p_table_name => 'PER_GRADE_SPINES_F',

1658: fnd_message.raise_error;
1659: else
1660: if p_datetrack_mode <> 'CORRECTION' then
1661: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode
1662: (p_table_name => 'PER_GRADE_SPINES_F',
1663: p_key_column_name => 'GRADE_SPINE_ID',
1664: p_key_column_value => l_grade_spine_id,
1665: p_effective_date => p_effective_date);
1666: else

Line 1695: update per_grade_spines_f

1691:
1692: /* if(grd_spine.information103 in ('Y','B')) then
1693: if grd_spine.information259 is not null then
1694: begin
1695: update per_grade_spines_f
1696: set ceiling_step_id = l_ceiling_step_id
1697: where grade_spine_id = l_grade_spine_id
1698: and p_effective_date between effective_start_date and effective_end_date;
1699: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);

Line 1712: update per_grade_spines_f

1708: if (grd_spine.information103 in ('S','B')) then
1709: hr_utility.set_location('grd_spine exists,starting step updated',10);
1710: if grd_spine.information228 is not null then
1711: begin
1712: update per_grade_spines_f
1713: set starting_step = l_starting_step
1714: where grade_spine_id = l_grade_spine_id
1715: and p_effective_date between effective_start_date and effective_end_date;
1716: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);

Line 2096: FROM per_grade_spines_f pgs

2092: -- Create step as of grade spine start date
2093: begin
2094: SELECT pgs.EFFECTIVE_START_DATE
2095: INTO l_grd_effstdt
2096: FROM per_grade_spines_f pgs
2097: WHERE pgs.grade_spine_id = l_grd_sp_id
2098: AND p_effective_date BETWEEN pgs.effective_start_date
2099: AND pgs.effective_end_date;
2100: exception

Line 2125: update per_grade_spines_f

2121: hr_utility.set_location('step_writeback done',22);
2122: if nvl(step_rec.information98,'N') = 'Y' and l_step_id is not null then
2123: hr_utility.set_location('ceiling step, update grd_sp',23);
2124: begin
2125: update per_grade_spines_f
2126: set ceiling_step_id = l_step_id
2127: where grade_spine_id = l_grd_sp_id
2128: and p_effective_date between effective_start_date and effective_end_date;
2129: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);