APPS.PA_OTC_API dependencies on HXC_MAPPING_COMPONENTS

Line 181: G_Billable_Segment HXC_MAPPING_COMPONENTS.SEGMENT%TYPE;

177: G_PO_Header_Id Number := Null;
178: -- End PA.M/CWK changes
179:
180: -- Added to support performance change in OTL, when creating billable flag record
181: G_Billable_Segment HXC_MAPPING_COMPONENTS.SEGMENT%TYPE;
182:
183: /* Added Variable for bug 11711383 */
184: G_Delete_op Varchar2(10) :='N';
185: G_Delete_Change Varchar2(10) :='N';

Line 8069: from hxc_mapping_components mc,

8065:
8066: G_Stage := 'Get the segment for the billable_flag from hxc table.';
8067: select mc.segment
8068: Into G_Billable_Segment
8069: from hxc_mapping_components mc,
8070: hxc_bld_blk_info_types bbit
8071: where mc.field_name = 'BILLABLE_FLAG'
8072: and bbit.bld_blk_info_type_id = mc.bld_blk_info_type_id
8073: and bbit.bld_blk_info_type = 'PROJECTS';