APPS.OZF_AR_SETTLEMENT_PVT dependencies on OZF_LOOKUPS

Line 382: , ozf_lookups lk

378: c.amount,
379: c.amount_remaining,
380: c.amount_settled
381: FROM ozf_claims c
382: , ozf_lookups lk
383: WHERE root_claim_id = cv_claim_id
384: AND c.status_code = lk.lookup_code
385: AND lk.lookup_type = 'OZF_CLAIM_STATUS'
386: ORDER BY claim_number;

Line 457: , ozf_lookups lk

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
460: AND lk.lookup_type = 'OZF_OBJECT_CLASS'
461: AND ln.source_object_id = trx.customer_trx_id;

Line 1963: FROM ozf_lookups

1959: WHERE reason_code_id = cv_reason_code_id ;
1960: */
1961: CURSOR csr_pmt_method (cv_payment_method IN VARCHAR2) IS
1962: SELECT meaning
1963: FROM ozf_lookups
1964: WHERE lookup_type = 'OZF_PAYMENT_METHOD'
1965: AND lookup_code = cv_payment_method ;
1966:
1967: CURSOR csr_salesrep_name(cv_salesrep_id IN NUMBER, cv_org_id IN NUMBER) IS

Line 1977: FROM ozf_lookups

1973: AND s.org_id = cv_org_id;
1974:
1975: CURSOR csr_status_meaning(cv_status_code IN VARCHAR2) IS
1976: SELECT meaning
1977: FROM ozf_lookups
1978: WHERE lookup_type = 'OZF_CLAIM_STATUS'
1979: AND lookup_code = cv_status_code;
1980:
1981: CURSOR csr_ar_cm_reason_code(cv_reason_code_id IN NUMBER) IS