DBA Data[Home] [Help]

APPS.PQH_OPS_BUS dependencies on PQH_DE_WRKPLC_VLDTN_OPS

Line 30: , pqh_de_wrkplc_vldtn_ops ops

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_de_wrkplc_vldtn_ops ops
31: where ops.wrkplc_vldtn_op_id = p_wrkplc_vldtn_op_id
32: and pbg.business_group_id = ops.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pqh_de_wrkplc_vldtn_ops ops

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pqh_de_wrkplc_vldtn_ops ops
95: where ops.wrkplc_vldtn_op_id = p_wrkplc_vldtn_op_id
96: and pbg.business_group_id = ops.business_group_id;
97: --
98: -- Declare local variables

Line 245: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_OPS.WRKPLC_VLDTN_OP_ID') then

241: End If;
242: Exception
243: when app_exception.application_exception then
244: if hr_multi_message.exception_add
245: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_OPS.WRKPLC_VLDTN_OP_ID') then
246: hr_utility.set_location(' Leaving:'||l_proc,60);
247: raise;
248: end if;
249: hr_utility.set_location(' Leaving:'||l_proc,70);