APPS.PQH_VER_BUS dependencies on PQH_DE_WRKPLC_VLDTN_VERS

Line 30: , pqh_de_wrkplc_vldtn_vers ver

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_de_wrkplc_vldtn_vers ver
31: where ver.wrkplc_vldtn_ver_id = p_wrkplc_vldtn_ver_id
32: and pbg.business_group_id = ver.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pqh_de_wrkplc_vldtn_vers ver

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pqh_de_wrkplc_vldtn_vers ver
95: where ver.wrkplc_vldtn_ver_id = p_wrkplc_vldtn_ver_id
96: and pbg.business_group_id = ver.business_group_id;
97: --
98: -- Declare local variables

Line 259: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.TARIFF_CONTRACT_CODE'

255: Close Tariff_Contract;
256: Exception
257: when app_exception.application_exception then
258: if hr_multi_message.exception_add
259: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.TARIFF_CONTRACT_CODE'
260: ) then
261: hr_utility.set_location(' Leaving:'||l_proc,60);
262: raise;
263: end if;

Line 302: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.TARIFF_GROUP_CODE'

298: Close Tariff_Group;
299: Exception
300: when app_exception.application_exception then
301: if hr_multi_message.exception_add
302: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.TARIFF_GROUP_CODE'
303: ) then
304: hr_utility.set_location(' Leaving:'||l_proc,60);
305: raise;
306: end if;

Line 356: l_Grade_id Pqh_De_Wrkplc_Vldtn_Vers.USER_ENTERABLE_GRADE_ID%TYPE := NULL;

352: g_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
353: f_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
354: e_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
355: d_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
356: l_Grade_id Pqh_De_Wrkplc_Vldtn_Vers.USER_ENTERABLE_GRADE_ID%TYPE := NULL;
357: l_Cnt Number(2) := 0;
358: Begin
359: hr_utility.set_location(l_proc, 10);
360: If p_rec.USER_ENTERABLE_GRADE_ID Is not Null Then

Line 400: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.DERIVED_GRADE_ID'

396: End If;
397: Exception
398: when app_exception.application_exception then
399: if hr_multi_message.exception_add
400: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.DERIVED_GRADE_ID'
401: ) then
402: hr_utility.set_location(' Leaving:'||l_proc,60);
403: raise;
404: end if;

Line 429: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.FREEZE'

425: End If;
426: Exception
427: when app_exception.application_exception then
428: if hr_multi_message.exception_add
429: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.FREEZE'
430: ) then
431: hr_utility.set_location(' Leaving:'||l_proc,60);
432: raise;
433: end if;