APPS.PQH_GSP_STAGE_TO_HR dependencies on HR_GENERAL

Line 129: where effective_end_date = hr_general.end_of_time

125: begin
126: select ler_id,name,effective_start_date
127: into l_ler_id,l_ler_name,l_effective_start_date
128: from ben_ler_f
129: where effective_end_date = hr_general.end_of_time
130: and business_group_id = p_business_group_id
131: and typ_cd ='GSP'
132: and lf_evt_oper_cd ='PROG';
133: hr_utility.set_location('life event '||substr(l_ler_name,1,40),10);

Line 158: where effective_end_date = hr_general.end_of_time

154: begin
155: select ler_id,name,effective_start_date
156: into l_ler_id,l_ler_name,l_effective_start_date
157: from ben_ler_f
158: where effective_end_date = hr_general.end_of_time
159: and business_group_id = p_business_group_id
160: and typ_cd ='GSP'
161: and lf_evt_oper_cd ='SYNC';
162: hr_utility.set_location('life event '||substr(l_ler_name,1,40),10);

Line 188: where effective_end_date = hr_general.end_of_time

184: begin
185: select pl_typ_id,name,effective_start_date
186: into l_pt_id,l_pt_name,l_effective_start_date
187: from ben_pl_typ_f
188: where effective_end_date = hr_general.end_of_time
189: and business_group_id = p_business_group_id
190: and opt_typ_cd ='GSP'
191: and pl_typ_stat_cd ='A';
192: hr_utility.set_location('pl_typ name '||substr(l_pt_name,1,40),10);

Line 1654: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');

1650: p_effective_date => p_effective_date);
1651: hr_utility.set_location(' l_db_ovn is '||l_db_ovn,30);
1652: hr_utility.set_location(' l_gs_ovn is '||l_gs_ovn,30);
1653: if l_db_ovn <> l_gs_ovn then
1654: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');
1655: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1656: fnd_message.set_token('OBJECT ',l_object);
1657: fnd_message.set_token('OBJECT_NAME ',l_grade_spine_id);
1658: fnd_message.raise_error;

Line 1849: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','POINT');

1845: p_key_column_name => 'SPINAL_POINT_ID',
1846: p_key_column_value => l_point_id);
1847: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1848: if l_db_ovn <> l_point_ovn then
1849: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','POINT');
1850: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1851: fnd_message.set_token('OBJECT ',l_object);
1852: fnd_message.set_token('OBJECT_NAME ',point_rec.information98);
1853: fnd_message.raise_error;

Line 1988: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GRADE');

1984: p_key_column_name => 'GRADE_ID',
1985: p_key_column_value => l_grade_id);
1986: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1987: if l_db_ovn <> l_ovn then
1988: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GRADE');
1989: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1990: fnd_message.set_token('OBJECT ',l_object);
1991: fnd_message.set_token('OBJECT_NAME ',grd_rec.information5);
1992: fnd_message.raise_error;

Line 2241: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','SCALE');

2237: p_key_column_name => 'PARENT_SPINE_ID',
2238: p_key_column_value => l_scale_id);
2239: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2240: if l_db_ovn <> l_scale_ovn then
2241: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','SCALE');
2242: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2243: fnd_message.set_token('OBJECT ',l_object);
2244: fnd_message.set_token('OBJECT_NAME ',scl_rec.information98);
2245: fnd_message.raise_error;

Line 2473: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','HRRATE');

2469: p_key_column_value => l_hrrate_id,
2470: p_effective_date => l_effective_date);
2471: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2472: if l_db_ovn <> l_hrr_ovn then
2473: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','HRRATE');
2474: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2475: fnd_message.set_token('OBJECT ',l_object);
2476: fnd_message.set_token('OBJECT_NAME ',l_rate_type ||':'|| l_grd_sp_id);
2477: fnd_message.raise_error;