APPS.GMF_MIGRATION dependencies on RA_CUST_TRX_TYPES_ALL

Line 1151: l_ar_trx_type_code RA_CUST_TRX_TYPES_ALL.name%TYPE;

1147: /************************
1148: * Local Variables *
1149: ************************/
1150:
1151: l_ar_trx_type_code RA_CUST_TRX_TYPES_ALL.name%TYPE;
1152:
1153: /****************
1154: * Cursors *
1155: ****************/

Line 1164: FROM ra_cust_trx_types_all rctta, ar_lookups al, gl_plcy_mst plcy

1160: p_legal_entity_id IN NUMBER
1161: )
1162: IS
1163: SELECT rctta.name
1164: FROM ra_cust_trx_types_all rctta, ar_lookups al, gl_plcy_mst plcy
1165: WHERE sysdate between nvl(rctta.start_date, sysdate-1) and nvl(rctta.end_date, sysdate+1)
1166: AND al.lookup_type = 'INV/CM'
1167: AND al.lookup_code = rctta.type
1168: AND rctta.org_id = plcy.org_id

Line 6578: l_ar_trx_type_code RA_CUST_TRX_TYPES_ALL.name%TYPE;

6574: l_price_element_type_id PO_COST_MST.price_element_type_id%TYPE;
6575: l_cost_cmpntcls_code CM_CMPT_MST.cost_cmpntcls_code%TYPE;
6576: l_Order_type_code OP_ORDR_TYP.Order_type_code%TYPE;
6577: l_Line_type_code GEM_LOOKUPS.meaning%TYPE;
6578: l_ar_trx_type_code RA_CUST_TRX_TYPES_ALL.name%TYPE;
6579:
6580: l_co_code t_co_code;
6581: l_orgn_code t_orgn_code;
6582: l_whse_code t_whse_code;