DBA Data[Home] [Help]

APPS.OZF_CLAIM_GRP dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 1958: FROM ar_receivable_applications_all

1954: -- Added for Bug5102282
1955: -- Get the payment_schedule_id
1956: CURSOR csr_applied_ps_id( cv_customer_trx_id IN NUMBER, cv_receipt_id IN NUMBER, cv_claim_id IN NUMBER) IS
1957: SELECT distinct applied_payment_schedule_id
1958: FROM ar_receivable_applications_all
1959: WHERE cash_receipt_id = cv_receipt_id
1960: AND applied_customer_trx_id = cv_customer_trx_id
1961: AND application_ref_type = 'CLAIM'
1962: AND secondary_application_ref_id = cv_claim_id

Line 1970: FROM ar_receivable_applications_all

1966: -- Added for Bug5102282
1967: -- Get the count of applications
1968: CURSOR csr_cnt_apply(cv_ps_id IN NUMBER, cv_receipt_id IN NUMBER, cv_claim_id IN NUMBER) IS
1969: SELECT COUNT(*)
1970: FROM ar_receivable_applications_all
1971: WHERE applied_payment_schedule_id = cv_ps_id
1972: AND cash_receipt_id <> cv_receipt_id
1973: AND application_ref_type = 'CLAIM'
1974: AND secondary_application_ref_id = cv_claim_id