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 364: From Per_Grade_Spines_F

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

Line 430: ,P_BASE_TABLE_NAME => 'PER_GRADE_SPINES_F'

426: End If;
427:
428: Dt_Api.FIND_DT_DEL_MODES
429: (P_EFFECTIVE_DATE => l_Effective_Date
430: ,P_BASE_TABLE_NAME => 'PER_GRADE_SPINES_F'
431: ,P_BASE_KEY_COLUMN => 'GRADE_SPINE_ID'
432: ,P_BASE_KEY_VALUE => l_Hr_grade_Scale_id
433: ,P_ZAP => L_ZAP
434: ,P_DELETE => L_DELETE

Line 1542: from per_grade_spines_f

1538: begin
1539: begin
1540: select grade_spine_id,parent_spine_id
1541: into l_grade_spine_id,l_parent_spine_id
1542: from per_grade_spines_f
1543: where grade_id = p_grade_id
1544: and p_effective_date between effective_start_date and effective_end_date;
1545: hr_utility.set_location('grade_spine id is '||l_grade_spine_id,35);
1546: exception

Line 1644: from per_grade_spines_f

1640: -- If the payscale linked to grade is changed create grade spine as of effective date
1641: begin
1642: select grade_id
1643: into l_grade_id
1644: from per_grade_spines_f
1645: where grade_id = l_grade_id
1646: and rownum < 2 ;
1647: l_grd_effstdt := p_effective_date;
1648: exception

Line 1686: (p_table_name => 'PER_GRADE_SPINES_F',

1682: hr_utility.set_location('grd_spine exists,ceiling step updated',10);
1683: begin
1684: hr_utility.set_location('going for upd',30);
1685: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1686: (p_table_name => 'PER_GRADE_SPINES_F',
1687: p_key_column_name => 'GRADE_SPINE_ID',
1688: p_key_column_value => l_grade_spine_id,
1689: p_effective_date => p_effective_date);
1690: hr_utility.set_location(' l_db_ovn is '||l_db_ovn,30);

Line 1701: (p_table_name => 'PER_GRADE_SPINES_F',

1697: fnd_message.raise_error;
1698: else
1699: if p_datetrack_mode <> 'CORRECTION' then
1700: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode
1701: (p_table_name => 'PER_GRADE_SPINES_F',
1702: p_key_column_name => 'GRADE_SPINE_ID',
1703: p_key_column_value => l_grade_spine_id,
1704: p_effective_date => p_effective_date);
1705: else

Line 1734: update per_grade_spines_f

1730:
1731: /* if(grd_spine.information103 in ('Y','B')) then
1732: if grd_spine.information259 is not null then
1733: begin
1734: update per_grade_spines_f
1735: set ceiling_step_id = l_ceiling_step_id
1736: where grade_spine_id = l_grade_spine_id
1737: and p_effective_date between effective_start_date and effective_end_date;
1738: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);

Line 1751: update per_grade_spines_f

1747: if (grd_spine.information103 in ('S','B')) then
1748: hr_utility.set_location('grd_spine exists,starting step updated',10);
1749: if grd_spine.information228 is not null then
1750: begin
1751: update per_grade_spines_f
1752: set starting_step = l_starting_step
1753: where grade_spine_id = l_grade_spine_id
1754: and p_effective_date between effective_start_date and effective_end_date;
1755: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);

Line 2136: FROM per_grade_spines_f pgs

2132: -- Create step as of grade spine start date
2133: begin
2134: SELECT pgs.EFFECTIVE_START_DATE
2135: INTO l_grd_effstdt
2136: FROM per_grade_spines_f pgs
2137: WHERE pgs.grade_spine_id = l_grd_sp_id
2138: AND p_effective_date BETWEEN pgs.effective_start_date
2139: AND pgs.effective_end_date;
2140: exception

Line 2165: update per_grade_spines_f

2161: hr_utility.set_location('step_writeback done',22);
2162: if nvl(step_rec.information98,'N') = 'Y' and l_step_id is not null then
2163: hr_utility.set_location('ceiling step, update grd_sp',23);
2164: begin
2165: update per_grade_spines_f
2166: set ceiling_step_id = l_step_id
2167: where grade_spine_id = l_grd_sp_id
2168: and p_effective_date between effective_start_date and effective_end_date;
2169: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);