APPS.OZF_SETTLEMENT_DOC_PVT dependencies on AP_LOOKUP_CODES

Line 1277: FROM ap_lookup_codes lkp

1273: -- Fix for bug 4897546
1274: IF l_claim_rec.payment_method in ( 'CHECK','EFT','WIRE','AP_DEFAULT') THEN
1275: UPDATE ozf_settlement_docs_all stlmnt_docs
1276: SET payment_status = (SELECT SUBSTRB(lkp.displayed_field,1,30)
1277: FROM ap_lookup_codes lkp
1278: where lkp.lookup_type = 'CHECK STATE'
1279: and lkp.lookup_code IN (select status_lookup_code
1280: FROM ap_invoice_payments pay, ap_checks chk
1281: WHERE pay.check_id = chk.check_id

Line 5402: FROM ap_lookup_codes

5398:
5399: -- Added for 14126231
5400: CURSOR csr_ap_debit_trx_type(cv_trx_type IN VARCHAR2) IS
5401: SELECT displayed_field
5402: FROM ap_lookup_codes
5403: WHERE lookup_code = cv_trx_type
5404: AND lookup_type = 'INVOICE TYPE';
5405:
5406: CURSOR csr_ap_trx_type(cv_trx_type IN VARCHAR2) IS

Line 5408: FROM ap_lookup_codes

5404: AND lookup_type = 'INVOICE TYPE';
5405:
5406: CURSOR csr_ap_trx_type(cv_trx_type IN VARCHAR2) IS
5407: SELECT displayed_field
5408: FROM ap_lookup_codes
5409: WHERE lookup_code = cv_trx_type
5410: AND lookup_type = 'PAYMENT METHOD';
5411:
5412: BEGIN

Line 5689: FROM ap_lookup_codes

5685:
5686: -- Added for 14126231
5687: CURSOR csr_ap_debit_trx_type(cv_trx_type IN VARCHAR2) IS
5688: SELECT displayed_field
5689: FROM ap_lookup_codes
5690: WHERE lookup_code = cv_trx_type
5691: AND lookup_type = 'INVOICE TYPE';
5692:
5693: CURSOR csr_ap_trx_type(cv_trx_type IN VARCHAR2) IS

Line 5695: FROM ap_lookup_codes

5691: AND lookup_type = 'INVOICE TYPE';
5692:
5693: CURSOR csr_ap_trx_type(cv_trx_type IN VARCHAR2) IS
5694: SELECT displayed_field
5695: FROM ap_lookup_codes
5696: WHERE lookup_code = cv_trx_type
5697: AND lookup_type = 'PAYMENT METHOD';
5698:
5699: