APPS.PQH_LVL_BUS dependencies on PQH_DE_WRKPLC_VLDTN_LVLNUMS

Line 30: , pqh_de_wrkplc_vldtn_lvlnums lvl

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_de_wrkplc_vldtn_lvlnums lvl
31: where lvl.wrkplc_vldtn_lvlnum_id = p_wrkplc_vldtn_lvlnum_id
32: and pbg.business_group_id = lvl.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pqh_de_wrkplc_vldtn_lvlnums lvl

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pqh_de_wrkplc_vldtn_lvlnums lvl
95: where lvl.wrkplc_vldtn_lvlnum_id = p_wrkplc_vldtn_lvlnum_id
96: and pbg.business_group_id = lvl.business_group_id;
97: --
98: -- Declare local variables

Line 229: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_LVLNUMS.LEVEL_NUMBER_ID'

225: Close Lvlnum;
226: Exception
227: when app_exception.application_exception then
228: if hr_multi_message.exception_add
229: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_LVLNUMS.LEVEL_NUMBER_ID'
230: ) then
231: hr_utility.set_location(' Leaving:'||l_proc,60);
232: raise;
233: end if;

Line 261: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_LVLNUMS.LEVEL_CODE_ID'

257: Close Lvlcode;
258: Exception
259: when app_exception.application_exception then
260: if hr_multi_message.exception_add
261: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_LVLNUMS.LEVEL_CODE_ID'
262: ) then
263: hr_utility.set_location(' Leaving:'||l_proc,60);
264: raise;
265: end if;