DBA Data[Home] [Help]

APPS.OZF_AR_SETTLEMENT_PVT dependencies on OZF_CLAIM_LINES

Line 418: FROM ozf_claim_lines ln

414: , ln.claim_currency_amount
415: , ln.tax_code
416: , ln.earnings_associated_flag
417: , ln.org_id
418: FROM ozf_claim_lines ln
419: WHERE ln.claim_id = cv_claim_id;
420:
421: TYPE line_detail_rec is RECORD ( claim_line_id NUMBER
422: , line_number NUMBER

Line 455: FROM ozf_claim_lines ln

451:
452: CURSOR csr_line_trx_info(cv_claim_line_id IN NUMBER) IS
453: SELECT lk.meaning
454: , trx.trx_number
455: FROM ozf_claim_lines ln
456: , ra_customer_trx trx
457: , ozf_lookups lk
458: WHERE ln.claim_line_id = cv_claim_line_id
459: AND ln.source_object_class = lk.lookup_code

Line 661: ,p_source_table => 'OZF_CLAIM_LINES_ALL'

657: ,x_return_status => l_return_status
658: ,x_msg_data => l_msg_data
659: ,x_msg_count => l_msg_count
660: ,p_source_id => l_line_detail_tbl(i).claim_line_id
661: ,p_source_table => 'OZF_CLAIM_LINES_ALL'
662: ,p_account_type => 'REC_CLEARING'
663: ,x_cc_id_tbl => l_cc_id_tbl
664: );
665: IF l_return_status <> FND_API.g_ret_sts_success THEN