APPS.FV_GEN_ARTRX_REIMB_PROC dependencies on FND_ID_FLEX_SEGMENTS

Line 226: FROM fnd_id_flex_segments

222: log(C_STATE_LEVEL, l_module, 'g_gl_nat_acc_segment: '||g_gl_nat_acc_segment);
223:
224: --finding the flex_value_set_id for the Natural Account segment
225: SELECT flex_value_set_id into g_ussgl_flex_value_set_id
226: FROM fnd_id_flex_segments
227: WHERE application_column_name = g_gl_nat_acc_segment
228: AND application_id = 101
229: AND id_flex_code = 'GL#'
230: AND id_flex_num = g_coa_id;

Line 244: FROM FND_ID_FLEX_SEGMENTS_VL

240: -- in the Federal Financial Options
241: BEGIN
242: SELECT application_column_name
243: INTO g_reimb_agreement_segment
244: FROM FND_ID_FLEX_SEGMENTS_VL
245: WHERE application_id = 101
246: AND id_flex_code = 'GL#'
247: AND id_flex_num = g_coa_id
248: AND enabled_flag = 'Y'

Line 372: FROM fnd_flex_values_vl f, fnd_id_flex_segments segs, ra_customer_trx_all r,

368: log(C_STATE_LEVEL, l_module, 'Child values of g_advance_acc: '||l_adv_child);
369:
370: l_sql_agree_range :=
371: 'SELECT f.flex_value
372: FROM fnd_flex_values_vl f, fnd_id_flex_segments segs, ra_customer_trx_all r,
373: ra_cust_trx_types_all t
374: WHERE f.flex_value_set_id =segs.flex_value_set_id AND
375: segs.application_column_name = :g_reimb_agreement_segment AND
376: segs.application_id = 101 AND