DBA Data[Home] [Help]

APPS.AR_CHARGE_SCHEDULE_PKG dependencies on AR_LOOKUPS

Line 610: FROM ar_lookups

606: IS
607: CURSOR c_lookup(p_type IN VARCHAR, p_code IN VARCHAR2)
608: IS
609: SELECT NULL
610: FROM ar_lookups
611: WHERE lookup_type = p_type
612: AND lookup_code = p_code
613: AND ( ENABLED_FLAG = 'Y' AND
614: TRUNC( SYSDATE ) BETWEEN

Line 1018: ar_lookups b

1014:
1015: CURSOR cl IS
1016: SELECT lookup_code
1017: FROM ar_charge_schedule_hdrs a,
1018: ar_lookups b
1019: WHERE a.schedule_header_id = P_SCHEDULE_HEADER_ID
1020: AND b.lookup_type = 'SCHEDULE_HEADER_TYPE'
1021: AND b.lookup_code = a.schedule_header_type;
1022: