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 1016: ar_lookups b

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