APPS.GHR_CCA_BUS dependencies on GHR_COMPL_APPEALS

Line 27: -- ghr_compl_appeals and PER_BUSINESS_GROUPS

23: --
24: -- Declare cursor
25: --
26: -- EDIT_HERE In the following cursor statement add join(s) between
27: -- ghr_compl_appeals 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_appeals cca

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_appeals cca
35: -- , EDIT_HERE table_name(s) 333
36: where cca.compl_appeal_id = p_compl_appeal_id;
37: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
38: --

Line 93: -- ghr_compl_appeals and PER_BUSINESS_GROUPS

89: --
90: -- Declare cursor
91: --
92: -- EDIT_HERE In the following cursor statement add join(s) between
93: -- ghr_compl_appeals 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_appeals cca

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_appeals cca
101: -- , EDIT_HERE table_name(s) 333
102: where cca.compl_appeal_id = p_compl_appeal_id;
103: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
104: --

Line 228: PROCEDURE chk_appealed_to(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,

224: -----------------------------------------------------------
225: --
226: --
227:
228: PROCEDURE chk_appealed_to(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
229: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,
230: p_effective_date in date,
231: p_object_version_number in number)
232:

Line 229: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,

225: --
226: --
227:
228: PROCEDURE chk_appealed_to(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
229: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,
230: p_effective_date in date,
231: p_object_version_number in number)
232:
233: IS

Line 308: PROCEDURE chk_reason_for_appeal(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,

304: ---------------------------------------------------------------
305: --
306: --
307:
308: PROCEDURE chk_reason_for_appeal(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
309: p_reason_for_appeal in ghr_compl_appeals.reason_for_appeal%TYPE,
310: p_effective_date in date,
311: p_object_version_number in number)
312:

Line 309: p_reason_for_appeal in ghr_compl_appeals.reason_for_appeal%TYPE,

305: --
306: --
307:
308: PROCEDURE chk_reason_for_appeal(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
309: p_reason_for_appeal in ghr_compl_appeals.reason_for_appeal%TYPE,
310: p_effective_date in date,
311: p_object_version_number in number)
312:
313: IS

Line 388: PROCEDURE chk_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,

384: ----------------------------------------------------------------
385: --
386: --
387:
388: PROCEDURE chk_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
389: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,
390: p_decision in ghr_compl_appeals.decision%TYPE,
391: p_effective_date in date,
392: p_object_version_number in number)

Line 389: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,

385: --
386: --
387:
388: PROCEDURE chk_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
389: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,
390: p_decision in ghr_compl_appeals.decision%TYPE,
391: p_effective_date in date,
392: p_object_version_number in number)
393:

Line 390: p_decision in ghr_compl_appeals.decision%TYPE,

386: --
387:
388: PROCEDURE chk_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
389: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,
390: p_decision in ghr_compl_appeals.decision%TYPE,
391: p_effective_date in date,
392: p_object_version_number in number)
393:
394: IS

Line 483: PROCEDURE chk_rfr_requested_by(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,

479: -----------------------------------------------------------------
480: --
481: --
482:
483: PROCEDURE chk_rfr_requested_by(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
484: p_rfr_requested_by in ghr_compl_appeals.rfr_requested_by%TYPE,
485: p_effective_date in date,
486: p_object_version_number in number)
487:

Line 484: p_rfr_requested_by in ghr_compl_appeals.rfr_requested_by%TYPE,

480: --
481: --
482:
483: PROCEDURE chk_rfr_requested_by(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
484: p_rfr_requested_by in ghr_compl_appeals.rfr_requested_by%TYPE,
485: p_effective_date in date,
486: p_object_version_number in number)
487:
488: IS

Line 563: PROCEDURE chk_rfr_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,

559: -----------------------------------------------------------------
560: --
561: --
562:
563: PROCEDURE chk_rfr_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
564: p_rfr_decision in ghr_compl_appeals.rfr_decision%TYPE,
565: p_effective_date in date,
566: p_object_version_number in number)
567:

Line 564: p_rfr_decision in ghr_compl_appeals.rfr_decision%TYPE,

560: --
561: --
562:
563: PROCEDURE chk_rfr_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
564: p_rfr_decision in ghr_compl_appeals.rfr_decision%TYPE,
565: p_effective_date in date,
566: p_object_version_number in number)
567:
568: IS