DBA Data[Home] [Help]

APPS.IEX_DUNNING_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 3781: from ar_payment_schedules_all ps,

3777: --
3778: cursor c_amount (IN_ID number) is
3779: select ps.amount_due_remaining,
3780: ps.invoice_currency_code
3781: from ar_payment_schedules_all ps,
3782: --iex_delinquencies_all del
3783: iex_delinquencies del
3784: where ps.payment_schedule_id (+)= del.payment_schedule_id
3785: and del.delinquency_id = in_id;

Line 5126: from ar_payment_schedules_all ps,

5122: --
5123: cursor c_amount (IN_ID number) is
5124: select ps.amount_due_remaining,
5125: ps.invoice_currency_code
5126: from ar_payment_schedules_all ps,
5127: --iex_delinquencies_all del
5128: iex_delinquencies del
5129: where ps.payment_schedule_id (+)= del.payment_schedule_id
5130: and del.delinquency_id = in_id;

Line 9831: from ar_payment_schedules_all ps,

9827: FUNCTION Party_currency_code(p_party_id NUMBER) RETURN VARCHAR2
9828: IS
9829: cursor c_amount (IN_ID number) is
9830: select ps.invoice_currency_code
9831: from ar_payment_schedules_all ps,
9832: iex_delinquencies del
9833: where ps.payment_schedule_id (+)= del.payment_schedule_id
9834: and del.party_cust_id = in_id;
9835: l_code VARCHAR2(15);

Line 9858: from ar_payment_schedules_all ps,

9854: FUNCTION acct_currency_code(p_account_id NUMBER) RETURN VARCHAR2
9855: IS
9856: cursor c_amount (IN_ID number) is
9857: select ps.invoice_currency_code
9858: from ar_payment_schedules_all ps,
9859: --iex_delinquencies_all del
9860: iex_delinquencies del
9861: where ps.payment_schedule_id (+)= del.payment_schedule_id
9862: and del.cust_account_id = in_id;

Line 9886: from ar_payment_schedules_all ps,

9882: FUNCTION site_currency_code(p_customer_site_use_id NUMBER) RETURN VARCHAR2
9883: IS
9884: cursor c_amount (IN_ID number) is
9885: select ps.invoice_currency_code
9886: from ar_payment_schedules_all ps,
9887: iex_delinquencies del
9888: where ps.payment_schedule_id (+)= del.payment_schedule_id
9889: and del.customer_site_use_id = in_id;
9890:

Line 9915: from ar_payment_schedules_all ps,

9911: FUNCTION party_amount_due_remaining(p_party_id NUMBER) RETURN NUMBER
9912: IS
9913: cursor c_amount (IN_ID number) is
9914: select sum(ps.acctd_amount_due_remaining)
9915: from ar_payment_schedules_all ps,
9916: iex_delinquencies del
9917: where ps.payment_schedule_id (+)= del.payment_schedule_id
9918: and del.party_cust_id = in_id;
9919: l_sum number;

Line 9942: from ar_payment_schedules_all ps,

9938: FUNCTION acct_amount_due_remaining(p_account_id NUMBER) RETURN NUMBER
9939: IS
9940: cursor c_amount (IN_ID number) is
9941: select sum(ps.acctd_amount_due_remaining)
9942: from ar_payment_schedules_all ps,
9943: --iex_delinquencies_all del
9944: iex_delinquencies del
9945: where ps.payment_schedule_id (+)= del.payment_schedule_id
9946: and del.cust_account_id = in_id;

Line 9970: from ar_payment_schedules_all ps,

9966: FUNCTION site_amount_due_remaining(p_customer_site_use_id NUMBER) RETURN NUMBER
9967: IS
9968: cursor c_amount (IN_ID number) is
9969: select sum(ps.acctd_amount_due_remaining)
9970: from ar_payment_schedules_all ps,
9971: iex_delinquencies del
9972: where ps.payment_schedule_id (+)= del.payment_schedule_id
9973: and del.customer_site_use_id = in_id;
9974: l_sum number;