DBA Data[Home] [Help]

APPS.GMF_MIGRATION dependencies on AR_LOOKUPS

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