eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_CAA_BUS dependencies on GHR_COMPL_AGENCY_APPEALS

Line 27: -- ghr_compl_agency_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_agency_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_agency_appeals caa

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_agency_appeals caa
35: -- , EDIT_HERE table_name(s) 333
36: where caa.compl_agency_appeal_id = p_compl_agency_appeal_id;
37: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
38: --

Line 93: -- ghr_compl_agency_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_agency_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_agency_appeals caa

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_agency_appeals caa
101: -- , EDIT_HERE table_name(s) 333
102: where caa.compl_agency_appeal_id = p_compl_agency_appeal_id;
103: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
104: --

Line 229: PROCEDURE chk_reason_for_appeal(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,

225: ---------------------------------------------------------------
226: --
227: --
228:
229: PROCEDURE chk_reason_for_appeal(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
230: p_reason_for_appeal in ghr_compl_agency_appeals.reason_for_appeal%TYPE,
231: p_effective_date in date,
232: p_object_version_number in number)
233:

Line 230: p_reason_for_appeal in ghr_compl_agency_appeals.reason_for_appeal%TYPE,

226: --
227: --
228:
229: PROCEDURE chk_reason_for_appeal(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
230: p_reason_for_appeal in ghr_compl_agency_appeals.reason_for_appeal%TYPE,
231: p_effective_date in date,
232: p_object_version_number in number)
233:
234: IS

Line 309: PROCEDURE chk_decision(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,

305: ----------------------------------------------------------------
306: --
307: --
308:
309: PROCEDURE chk_decision(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
310: p_decision in ghr_compl_agency_appeals.decision%TYPE,
311: p_effective_date in date,
312: p_object_version_number in number)
313:

Line 310: p_decision in ghr_compl_agency_appeals.decision%TYPE,

306: --
307: --
308:
309: PROCEDURE chk_decision(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
310: p_decision in ghr_compl_agency_appeals.decision%TYPE,
311: p_effective_date in date,
312: p_object_version_number in number)
313:
314: IS

Line 390: PROCEDURE chk_rfr_requested_by(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,

386: -----------------------------------------------------------------
387: --
388: --
389:
390: PROCEDURE chk_rfr_requested_by(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
391: p_rfr_requested_by in ghr_compl_agency_appeals.rfr_requested_by%TYPE,
392: p_effective_date in date,
393: p_object_version_number in number)
394:

Line 391: p_rfr_requested_by in ghr_compl_agency_appeals.rfr_requested_by%TYPE,

387: --
388: --
389:
390: PROCEDURE chk_rfr_requested_by(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
391: p_rfr_requested_by in ghr_compl_agency_appeals.rfr_requested_by%TYPE,
392: p_effective_date in date,
393: p_object_version_number in number)
394:
395: IS

Line 470: PROCEDURE chk_rfr_decision(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,

466: -----------------------------------------------------------------
467: --
468: --
469:
470: PROCEDURE chk_rfr_decision(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
471: p_rfr_decision in ghr_compl_agency_appeals.rfr_decision%TYPE,
472: p_effective_date in date,
473: p_object_version_number in number)
474:

Line 471: p_rfr_decision in ghr_compl_agency_appeals.rfr_decision%TYPE,

467: --
468: --
469:
470: PROCEDURE chk_rfr_decision(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
471: p_rfr_decision in ghr_compl_agency_appeals.rfr_decision%TYPE,
472: p_effective_date in date,
473: p_object_version_number in number)
474:
475: IS