DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on HXC_MAPPING_COMPONENTS

Line 168: G_Billable_Segment HXC_MAPPING_COMPONENTS.SEGMENT%TYPE;

164: G_PO_Header_Id Number := Null;
165: -- End PA.M/CWK changes
166:
167: -- Added to support performance change in OTL, when creating billable flag record
168: G_Billable_Segment HXC_MAPPING_COMPONENTS.SEGMENT%TYPE;
169:
170: -- 12i changes
171: G_OU_Tbl Pa_Txn_Interface_Items_Pkg.OU_Id_Typ;
172: G_Current_Org_Id Number := Pa_Moac_Utils.Get_Current_Org_Id;

Line 7186: from hxc_mapping_components mc,

7182:
7183: G_Stage := 'Get the segment for the billable_flag from hxc table.';
7184: select mc.segment
7185: Into G_Billable_Segment
7186: from hxc_mapping_components mc,
7187: hxc_bld_blk_info_types bbit
7188: where mc.field_name = 'BILLABLE_FLAG'
7189: and bbit.bld_blk_info_type_id = mc.bld_blk_info_type_id
7190: and bbit.bld_blk_info_type = 'PROJECTS';