APPS.FV_GEN_ARTRX_REIMB_PROC dependencies on RA_CUST_TRX_TYPES_ALL

Line 373: ra_cust_trx_types_all t

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
377: segs.id_flex_code = ''GL#'' AND

Line 724: from ra_cust_trx_types_all

720: END;
721: log(C_STATE_LEVEL, l_module, 'l_customer_name: '||l_customer_name);
722:
723: Select name into l_trx_type
724: from ra_cust_trx_types_all
725: where cust_trx_type_id = p_trx_header_tbl(1).cust_trx_type_id;
726:
727: log(C_STATE_LEVEL, l_module, 'l_trx_type: '||l_trx_type);
728:

Line 862: --Step 2a combine gl_c_c and ra_cust_trx_types_all to get the natural segment

858: AND rctd.set_of_books_id = g_ledger_id;
859:
860: log(C_STATE_LEVEL, l_module, 'l_agreement_rev_ccid: '||l_agreement_rev_ccid);
861: --Step 2 Get the Natural account segment of the Rec account of the transation type
862: --Step 2a combine gl_c_c and ra_cust_trx_types_all to get the natural segment
863: l_rev_nat_acc_sql:=
864: 'SELECT g.'||g_gl_nat_acc_segment||'
865: FROM ra_cust_trx_types_all t,
866: gl_code_combinations g

Line 865: FROM ra_cust_trx_types_all t,

861: --Step 2 Get the Natural account segment of the Rec account of the transation type
862: --Step 2a combine gl_c_c and ra_cust_trx_types_all to get the natural segment
863: l_rev_nat_acc_sql:=
864: 'SELECT g.'||g_gl_nat_acc_segment||'
865: FROM ra_cust_trx_types_all t,
866: gl_code_combinations g
867: WHERE t.cust_trx_type_id = :p_trx_type_id
868: AND t.gl_id_rev = g.code_combination_id
869: and g.chart_of_accounts_id = :g_coa_id';