DBA Data[Home] [Help]

APPS.OKL_AUTO_CASH_APPL_RULES_PVT dependencies on OKL_RCPT_CUST_CONT_BALANCES_UV

Line 1567: FROM OKL_RCPT_CUST_CONT_BALANCES_UV

1563: INVOICE_LINE_ID,
1564: LINE_NUMBER,
1565: AMOUNT_DUE_REMAINING,
1566: STY_ID
1567: FROM OKL_RCPT_CUST_CONT_BALANCES_UV
1568: WHERE KHR_ID = cp_contract_id
1569: AND ORG_ID = cp_org_id
1570: AND STATUS = 'OP';
1571:

Line 1585: FROM OKL_RCPT_CUST_CONT_BALANCES_UV

1581: INVOICE_LINE_ID,
1582: LINE_NUMBER,
1583: AMOUNT_DUE_REMAINING,
1584: STY_ID
1585: FROM OKL_RCPT_CUST_CONT_BALANCES_UV
1586: WHERE KHR_ID = cp_contract_id
1587: --asawanka changed for bug #5391874
1588: AND CUSTOMER_ACCOUNT_NUMBER = cp_customer_num
1589: AND ORG_ID = cp_org_id

Line 2350: FROM OKL_RCPT_CUST_CONT_BALANCES_UV

2346: INVOICE_LINE_ID,
2347: LINE_NUMBER,
2348: AMOUNT_DUE_REMAINING,
2349: INVOICE_DUE_DATE
2350: FROM OKL_RCPT_CUST_CONT_BALANCES_UV
2351: WHERE CUSTOMER_ACCOUNT_NUMBER = cp_customer_num
2352: AND ORG_ID = cp_org_id
2353: AND STATUS = 'OP'
2354: AND CURRENCY_CODE = cp_curr_code

Line 2368: FROM OKL_RCPT_CUST_CONT_BALANCES_UV

2364: INVOICE_LINE_ID,
2365: LINE_NUMBER,
2366: AMOUNT_DUE_REMAINING,
2367: INVOICE_DUE_DATE
2368: FROM OKL_RCPT_CUST_CONT_BALANCES_UV
2369: WHERE CUSTOMER_ACCOUNT_NUMBER = cp_customer_num
2370: AND ORG_ID = cp_org_id
2371: AND STATUS = 'OP'
2372: -- AND AMOUNT_DUE_REMAINING > 0