DBA Data[Home] [Help]

APPS.GHR_CMP_BUS dependencies on GHR_COMPLAINTS2

Line 29: , ghr_complaints2 cmp

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , ghr_complaints2 cmp
30: where cmp.complaint_id = p_complaint_id
31: and pbg.business_group_id = cmp.business_group_id;
32: --
33: -- Declare local variables

Line 89: , ghr_complaints2 cmp

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , ghr_complaints2 cmp
90: where cmp.complaint_id = p_complaint_id
91: and pbg.business_group_id (+) = cmp.business_group_id;
92: --
93: -- Declare local variables

Line 324: ,p_descflex_name => 'GHR_COMPLAINTS2'

320: -- b) During insert.
321: --
322: hr_dflex_utility.ins_or_upd_descflex_attribs
323: (p_appl_short_name => 'GHR'
324: ,p_descflex_name => 'GHR_COMPLAINTS2'
325: ,p_attribute_category => p_rec.attribute_category
326: ,p_attribute1_name => 'ATTRIBUTE1'
327: ,p_attribute1_value => p_rec.attribute1
328: ,p_attribute2_name => 'ATTRIBUTE2'