APPS.OTA_TMT_BUS dependencies on OTA_TP_MEASUREMENT_TYPES

Line 20: (p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE

16: -- ---------------------------------------------------------------------------
17: -- |----------------------< set_security_group_id >--------------------------|
18: -- ---------------------------------------------------------------------------
19: Procedure set_security_group_id
20: (p_tp_measurement_type_id in ota_tp_measurement_types.tp_measurement_type_id%TYPE
21: ) is
22: --
23: -- Declare cursor
24: --

Line 28: ,ota_tp_measurement_types tmt

24: --
25: cursor csr_sec_grp is
26: select inf.org_information14
27: from hr_organization_information inf
28: ,ota_tp_measurement_types tmt
29: where tmt.tp_measurement_type_id = p_tp_measurement_type_id
30: and inf.organization_id = tmt.business_group_id
31: and inf.org_information_context || '' = 'Business Group Information';
32:

Line 91: , ota_tp_measurement_types tmt

87: --
88: cursor csr_leg_code is
89: select pbg.legislation_code
90: from per_business_groups pbg
91: , ota_tp_measurement_types tmt
92: where tmt.tp_measurement_type_id = p_tp_measurement_type_id
93: and pbg.business_group_id = tmt.business_group_id;
94: --
95: -- Declare local variables

Line 259: ,p_descflex_name => 'OTA_TP_MEASUREMENT_TYPES'

255: -- b) During insert.
256: --
257: hr_dflex_utility.ins_or_upd_descflex_attribs
258: (p_appl_short_name => 'OTA'
259: ,p_descflex_name => 'OTA_TP_MEASUREMENT_TYPES'
260: ,p_attribute_category => p_rec.attribute_category
261: ,p_attribute1_name => 'ATTRIBUTE1'
262: ,p_attribute1_value => p_rec.attribute1
263: ,p_attribute2_name => 'ATTRIBUTE2'