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 2344: FROM OKL_RCPT_CUST_CONT_BALANCES_UV

2340: INVOICE_LINE_ID,
2341: LINE_NUMBER,
2342: AMOUNT_DUE_REMAINING,
2343: INVOICE_DUE_DATE
2344: FROM OKL_RCPT_CUST_CONT_BALANCES_UV
2345: WHERE CUSTOMER_ACCOUNT_NUMBER = cp_customer_num
2346: AND ORG_ID = cp_org_id
2347: AND STATUS = 'OP'
2348: AND CURRENCY_CODE = cp_curr_code

Line 2362: FROM OKL_RCPT_CUST_CONT_BALANCES_UV

2358: INVOICE_LINE_ID,
2359: LINE_NUMBER,
2360: AMOUNT_DUE_REMAINING,
2361: INVOICE_DUE_DATE
2362: FROM OKL_RCPT_CUST_CONT_BALANCES_UV
2363: WHERE CUSTOMER_ACCOUNT_NUMBER = cp_customer_num
2364: AND ORG_ID = cp_org_id
2365: AND STATUS = 'OP'
2366: -- AND AMOUNT_DUE_REMAINING > 0