APPS.OZF_AR_PAYMENT_PVT dependencies on OZF_CLAIM_LINES_ALL

Line 2491: ozf_claim_lines_all cli

2487: AVG(cli.rate) rate,
2488: SUM(NVL(cli.claim_currency_amount,0)) amount
2489: FROM ar_receivable_applications_all ar,
2490: ozf_claims_all cla,
2491: ozf_claim_lines_all cli
2492: WHERE cla.claim_id = cli.claim_id
2493: AND ar.cash_receipt_id = cla.receipt_id
2494: AND ar.status ='APP'
2495: AND ar.display ='Y'

Line 3379: FROM ozf_claim_lines_all

3375:
3376: --//Bug 12340283
3377: CURSOR csr_claim_lines(cv_claim_id IN NUMBER) IS
3378: SELECT source_object_id, sum(claim_currency_amount) amt
3379: FROM ozf_claim_lines_all
3380: WHERE claim_id = cv_claim_id
3381: GROUP BY source_object_id;
3382:
3383: /*CURSOR csr_claim_lines_ar(cv_claim_id IN NUMBER) IS

Line 3389: ozf_claim_lines_all cli

3385: cli.source_object_id,
3386: SUM(cli.claim_currency_amount) amt
3387: FROM ar_receivable_applications_all ar,
3388: ozf_claims_all cla,
3389: ozf_claim_lines_all cli
3390: WHERE cla.claim_id = cli.claim_id
3391: AND ar.cash_receipt_id = cla.receipt_id
3392: AND ar.status ='APP'
3393: AND ar.display ='Y'

Line 3404: ozf_claim_lines_all cli

3400: cli.source_object_id,
3401: SUM(cli.claim_currency_amount) amt
3402: FROM
3403: ozf_claims_all cla,
3404: ozf_claim_lines_all cli
3405: WHERE cla.claim_id = cli.claim_id
3406: AND cla.claim_id = cv_claim_id
3407: GROUP BY cli.source_object_id;
3408:

Line 3413: ozf_claim_lines_all cli

3409: CURSOR get_applied_invoice_cnt(cv_claim_id IN NUMBER) IS
3410: SELECT count(*)
3411: FROM ar_receivable_applications_all ar,
3412: ozf_claims_all cla,
3413: ozf_claim_lines_all cli
3414: WHERE cla.claim_id = cli.claim_id
3415: AND ar.cash_receipt_id = cla.receipt_id
3416: AND ar.status ='APP'
3417: AND ar.display ='Y'