DBA Data[Home] [Help]

APPS.AP_ACCTG_PAY_ROUND_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 369: ap_system_parameters_all asp

365: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
366: SELECT SUM(amount), count(1)
367: FROM ap_invoice_distributions_all aid,
368: xla_events evnt,
369: ap_system_parameters_all asp
370: WHERE aid.accounting_event_id = p_acct_event_id
371: AND aid.accounting_event_id = evnt.event_id
372: AND evnt.event_type_code IN ('INVOICE ADJUSTED',
373: 'CREDIT MEMO ADJUSTED',

Line 2942: l_invrate_for_prepay AP_SYSTEM_PARAMETERS_ALL.INVRATE_FOR_PREPAY_TAX%TYPE;

2938: ,P_Calling_Sequence IN VARCHAR2
2939: ) IS
2940:
2941: l_curr_calling_sequence VARCHAR2(2000);
2942: l_invrate_for_prepay AP_SYSTEM_PARAMETERS_ALL.INVRATE_FOR_PREPAY_TAX%TYPE;
2943:
2944: l_sum_pay_base_amt NUMBER;
2945: l_sum_pay_paid_base_amt NUMBER;
2946: l_sum_pay_clrd_base_amt NUMBER;

Line 2978: FROM ap_system_parameters_all ASP,

2974: BEGIN
2975:
2976: SELECT NVL(ASP.Invrate_for_prepay_tax, 'N')
2977: INTO l_invrate_for_prepay
2978: FROM ap_system_parameters_all ASP,
2979: ap_prepay_history_all APH
2980: WHERE ASP.Org_id = APH.Org_id
2981: AND APH.Prepay_history_id = P_Prepay_Hist_Rec.Prepay_History_ID;
2982:

Line 3253: ap_system_parameters_all aps,

3249: decode(ac.future_pay_due_date, NULL, 'CREATED', 'MATURITY')) type,
3250: ac.amount
3251: INTO l_ac_base_amount, l_transaction_type, l_ac_amount
3252: FROM ap_checks_all ac,
3253: ap_system_parameters_all aps,
3254: ap_invoice_payments_all aip
3255: WHERE ac.org_id = aps.org_id
3256: AND ac.check_id = P_XLA_Event_Rec.source_id_int_1
3257: AND aip.check_id = ac.check_id