APPS.OTA_CRT_FINANCE_SEGMENT dependencies on OTA_HR_GL_FLEX_MAPS

Line 100: l_hr_cost_segment ota_hr_gl_flex_maps.hr_cost_segment%type;

96: l_auto_transfer varchar2(1) := FND_PROFILE.VALUE('OTA_SSHR_AUTO_GL_TRANSFER');
97: l_transfer_status ota_finance_headers.transfer_status%type;
98: l_administrator ota_finance_headers.administrator%type;
99: l_date_format varchar2(200);
100: l_hr_cost_segment ota_hr_gl_flex_maps.hr_cost_segment%type;
101:
102: l_offering_id ota_events.offering_id%type;
103:
104: CURSOR THG_FROM(p_business_group_id in number)

Line 113: FROM OTA_HR_GL_FLEX_MAPS THG

109: ,thg.SEGMENT_NUM
110: ,thg.HR_DATA_SOURCE
111: ,thg.CONSTANT
112: ,thg.HR_COST_SEGMENT
113: FROM OTA_HR_GL_FLEX_MAPS THG
114: ,OTA_CROSS_CHARGES TCC
115: WHERE THG.Cross_charge_id = TCC.Cross_charge_id and
116: TCC.Business_group_id = p_business_group_id and
117: TCC.Type = 'E' and

Line 132: FROM OTA_HR_GL_FLEX_MAPS THG

128: ,thg.SEGMENT_NUM
129: ,thg.HR_DATA_SOURCE
130: ,thg.CONSTANT
131: ,thg.HR_COST_SEGMENT
132: FROM OTA_HR_GL_FLEX_MAPS THG
133: ,OTA_CROSS_CHARGES TCC
134: WHERE THG.Cross_charge_id = TCC.Cross_charge_id and
135: TCC.Business_group_id = p_business_group_id_to and
136: TCC.Type = 'E' and