APPS.PQH_DEF_BUS dependencies on PQH_DE_WRKPLC_VLDTNS

Line 30: , pqh_de_wrkplc_vldtns def

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_de_wrkplc_vldtns def
31: where def.wrkplc_vldtn_id = p_wrkplc_vldtn_id
32: and pbg.business_group_id = def.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pqh_de_wrkplc_vldtns def

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pqh_de_wrkplc_vldtns def
95: where def.wrkplc_vldtn_id = p_wrkplc_vldtn_id
96: and pbg.business_group_id = def.business_group_id;
97: --
98: -- Declare local variables

Line 223: from Pqh_De_Wrkplc_Vldtns

219: --
220:
221: Cursor Vldtn_Name is
222: Select Validation_Name
223: from Pqh_De_Wrkplc_Vldtns
224: Where Validation_Name like P_Rec.Validation_Name
225: and Business_Group_Id = P_Rec.Business_Group_Id;
226:
227: l_Validation_Name Pqh_De_Wrkplc_Vldtns.Validation_Name%TYPE;

Line 227: l_Validation_Name Pqh_De_Wrkplc_Vldtns.Validation_Name%TYPE;

223: from Pqh_De_Wrkplc_Vldtns
224: Where Validation_Name like P_Rec.Validation_Name
225: and Business_Group_Id = P_Rec.Business_Group_Id;
226:
227: l_Validation_Name Pqh_De_Wrkplc_Vldtns.Validation_Name%TYPE;
228: l_proc varchar2(72) := g_package || 'Unique_Validation_Name';
229:
230: Begin
231: hr_utility.set_location(l_proc, 10);

Line 243: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.Validation_Name'

239: Close Vldtn_Name;
240: Exception
241: when app_exception.application_exception then
242: if hr_multi_message.exception_add
243: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.Validation_Name'
244: ) then
245: hr_utility.set_location(' Leaving:'||l_proc,60);
246: raise;
247: end if;

Line 264: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.Employment_Type'

260: End If;
261: Exception
262: when app_exception.application_exception then
263: if hr_multi_message.exception_add
264: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.Employment_Type'
265: ) then
266: hr_utility.set_location(' Leaving:'||l_proc,60);
267: raise;
268: end if;

Line 285: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.REMUNERATION_REGULATION') then

281: End If;
282: Exception
283: when app_exception.application_exception then
284: if hr_multi_message.exception_add
285: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.REMUNERATION_REGULATION') then
286: hr_utility.set_location(' Leaving:'||l_proc,60);
287: raise;
288: end if;
289: hr_utility.set_location(' Leaving:'||l_proc,70);

Line 314: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.WRKPLC_VLDTN_ID'

310: Close Del;
311: Exception
312: when app_exception.application_exception then
313: if hr_multi_message.exception_add
314: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.WRKPLC_VLDTN_ID'
315: ) then
316: hr_utility.set_location(' Leaving:'||l_proc,60);
317: raise;
318: end if;