APPS.GHR_CDT_BUS dependencies on GHR_COMPL_CA_DETAILS

Line 27: -- ghr_compl_ca_details and PER_BUSINESS_GROUPS

23: --
24: -- Declare cursor
25: --
26: -- EDIT_HERE In the following cursor statement add join(s) between
27: -- ghr_compl_ca_details and PER_BUSINESS_GROUPS
28: -- so that the security_group_id for
29: -- the current business group context can be derived.
30: -- Remove this comment when the edit has been completed.
31: cursor csr_sec_grp is

Line 34: , ghr_compl_ca_details cdt

30: -- Remove this comment when the edit has been completed.
31: cursor csr_sec_grp is
32: select pbg.security_group_id
33: from per_business_groups pbg
34: , ghr_compl_ca_details cdt
35: -- , EDIT_HERE table_name(s) 333
36: where cdt.compl_ca_detail_id = p_compl_ca_detail_id;
37: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
38: --

Line 93: -- ghr_compl_ca_details and PER_BUSINESS_GROUPS

89: --
90: -- Declare cursor
91: --
92: -- EDIT_HERE In the following cursor statement add join(s) between
93: -- ghr_compl_ca_details and PER_BUSINESS_GROUPS
94: -- so that the legislation_code for
95: -- the current business group context can be derived.
96: -- Remove this comment when the edit has been completed.
97: cursor csr_leg_code is

Line 100: , ghr_compl_ca_details cdt

96: -- Remove this comment when the edit has been completed.
97: cursor csr_leg_code is
98: select pbg.legislation_code
99: from per_business_groups pbg
100: , ghr_compl_ca_details cdt
101: -- , EDIT_HERE table_name(s) 333
102: where cdt.compl_ca_detail_id = p_compl_ca_detail_id;
103: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
104: --

Line 229: PROCEDURE chk_category(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,

225: -----------------------------------------------------------
226: --
227: --
228:
229: PROCEDURE chk_category(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
230: p_category in ghr_compl_ca_details.category%TYPE,
231: p_effective_date in date,
232: p_object_version_number in number)
233:

Line 230: p_category in ghr_compl_ca_details.category%TYPE,

226: --
227: --
228:
229: PROCEDURE chk_category(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
230: p_category in ghr_compl_ca_details.category%TYPE,
231: p_effective_date in date,
232: p_object_version_number in number)
233:
234: IS

Line 309: PROCEDURE chk_type(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,

305: ------------------------------------------------------------------
306: --
307: --
308: /*
309: PROCEDURE chk_type(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
310: p_category in ghr_compl_ca_details.category%TYPE,
311: p_type in ghr_compl_ca_details.type%TYPE,
312: p_effective_date in date,
313: p_object_version_number in number)

Line 310: p_category in ghr_compl_ca_details.category%TYPE,

306: --
307: --
308: /*
309: PROCEDURE chk_type(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
310: p_category in ghr_compl_ca_details.category%TYPE,
311: p_type in ghr_compl_ca_details.type%TYPE,
312: p_effective_date in date,
313: p_object_version_number in number)
314:

Line 311: p_type in ghr_compl_ca_details.type%TYPE,

307: --
308: /*
309: PROCEDURE chk_type(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
310: p_category in ghr_compl_ca_details.category%TYPE,
311: p_type in ghr_compl_ca_details.type%TYPE,
312: p_effective_date in date,
313: p_object_version_number in number)
314:
315: IS

Line 402: PROCEDURE chk_phase(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,

398: ----------------------------------------------------------------
399: --
400: --
401:
402: PROCEDURE chk_phase(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
403: p_phase in ghr_compl_ca_details.phase%TYPE,
404: p_effective_date in date,
405: p_object_version_number in number)
406:

Line 403: p_phase in ghr_compl_ca_details.phase%TYPE,

399: --
400: --
401:
402: PROCEDURE chk_phase(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
403: p_phase in ghr_compl_ca_details.phase%TYPE,
404: p_effective_date in date,
405: p_object_version_number in number)
406:
407: IS