DBA Data[Home] [Help]

APPS.AR_LATE_CHARGE_PKG dependencies on AR_INTEREST_HEADERS_ALL

Line 2913: ar_interest_headers_all h,

2909: b.calculate_interest_to_date,
2910: s.late_charge_batch_source_id,
2911: lg.currency_code
2912: FROM ar_interest_batches_all b,
2913: ar_interest_headers_all h,
2914: ar_system_parameters_all s,
2915: gl_ledgers lg
2916: WHERE b.request_id = p_request_id
2917: AND b.org_id = s.org_id

Line 2933: FROM ar_interest_headers_all

2929:
2930: --{Check if the interest batch has some INV or DM before requiring the batch_source_id
2931: CURSOR ht(p_request_id IN NUMBER, p_worker_num IN NUMBER) IS
2932: SELECT NULL
2933: FROM ar_interest_headers_all
2934: WHERE request_id = p_request_id
2935: AND worker_num = p_worker_num
2936: AND display_flag = 'Y' --HYU CDI only document generating the Late Charge s Doc
2937: AND header_type IN ('INV','DM');