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 1693: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');

1689: p_effective_date => p_effective_date);
1690: hr_utility.set_location(' l_db_ovn is '||l_db_ovn,30);
1691: hr_utility.set_location(' l_gs_ovn is '||l_gs_ovn,30);
1692: if l_db_ovn <> l_gs_ovn then
1693: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');
1694: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1695: fnd_message.set_token('OBJECT ',l_object);
1696: fnd_message.set_token('OBJECT_NAME ',l_grade_spine_id);
1697: fnd_message.raise_error;

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

1884: p_key_column_name => 'SPINAL_POINT_ID',
1885: p_key_column_value => l_point_id);
1886: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1887: if l_db_ovn <> l_point_ovn then
1888: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','POINT');
1889: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1890: fnd_message.set_token('OBJECT ',l_object);
1891: fnd_message.set_token('OBJECT_NAME ',point_rec.information98);
1892: fnd_message.raise_error;

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

2024: p_key_column_name => 'GRADE_ID',
2025: p_key_column_value => l_grade_id);
2026: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2027: if l_db_ovn <> l_ovn then
2028: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GRADE');
2029: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2030: fnd_message.set_token('OBJECT ',l_object);
2031: fnd_message.set_token('OBJECT_NAME ',grd_rec.information5);
2032: fnd_message.raise_error;

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

2277: p_key_column_name => 'PARENT_SPINE_ID',
2278: p_key_column_value => l_scale_id);
2279: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2280: if l_db_ovn <> l_scale_ovn then
2281: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','SCALE');
2282: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2283: fnd_message.set_token('OBJECT ',l_object);
2284: fnd_message.set_token('OBJECT_NAME ',scl_rec.information98);
2285: fnd_message.raise_error;

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

2510: p_key_column_value => l_hrrate_id,
2511: p_effective_date => l_effective_date);
2512: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2513: if l_db_ovn <> l_hrr_ovn then
2514: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','HRRATE');
2515: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2516: fnd_message.set_token('OBJECT ',l_object);
2517: fnd_message.set_token('OBJECT_NAME ',l_rate_type ||':'|| l_grd_sp_id);
2518: fnd_message.raise_error;