DBA Data[Home] [Help]

APPS.AR_LATE_CHARGE_PKG dependencies on AR_INTEREST_HEADERS_ALL

Line 2953: ar_interest_headers_all h,

2949: b.calculate_interest_to_date,
2950: s.late_charge_batch_source_id,
2951: lg.currency_code
2952: FROM ar_interest_batches_all b,
2953: ar_interest_headers_all h,
2954: ar_system_parameters_all s,
2955: gl_ledgers lg
2956: WHERE b.request_id = p_request_id
2957: AND b.org_id = s.org_id

Line 2973: FROM ar_interest_headers_all

2969:
2970: --{Check if the interest batch has some INV or DM before requiring the batch_source_id
2971: CURSOR ht(p_request_id IN NUMBER, p_worker_num IN NUMBER) IS
2972: SELECT NULL
2973: FROM ar_interest_headers_all
2974: WHERE request_id = p_request_id
2975: AND worker_num = p_worker_num
2976: AND display_flag = 'Y' --HYU CDI only document generating the Late Charge s Doc
2977: AND header_type IN ('INV','DM');