APPS.AP_OPEN_ITEMS_REVAL_PKG dependencies on AP_LOOKUP_CODES

Line 52: ap_lookup_codes alc,

48: xla_ae_headers xah,
49: xla_ae_lines xal,
50: gl_code_combinations_kfv gcck,
51: ap_invoices_all ai,
52: ap_lookup_codes alc,
53: hz_parties hp,
54: ap_suppliers supp,
55: ap_supplier_sites_all site
56: where xte.ledger_id = $ledger_id$

Line 317: )a,ap_lookup_codes alc

313: from ap_open_items_reval_gt
314: where txn_id = ai.invoice_id)
315: and :G_DAILY_RATE_ERROR = ''N''
316: $bal_segment_condition$
317: )a,ap_lookup_codes alc
318: where alc.lookup_code = ''PAYMENT''
319: and alc.lookup_type = ''SYSTEM OPTIONS'' -- need modification
320: group by balancing_segment,
321: account_segment,

Line 384: ap_lookup_codes alc,

380: ap_invoice_distributions_all aid,
381: ap_invoice_lines_all ail,
382: gl_code_combinations_kfv gcck,
383: ap_invoices_all ai,
384: ap_lookup_codes alc,
385: hz_parties hp,
386: ap_suppliers supp,
387: ap_supplier_sites_all site
388: where asp.set_of_books_id = $ledger_id$

Line 473: ap_lookup_codes alc,

469: from ap_system_parameters_all asp,
470: ap_invoices_all ai,
471: ap_invoice_payments_all aip,
472: ap_checks_all ac,
473: ap_lookup_codes alc,
474: hz_parties hp,
475: ap_suppliers supp,
476: ap_supplier_sites_all site,
477: gl_code_combinations_kfv gcck

Line 973: from ap_lookup_codes

969: and gps.application_id = c_application_id;
970:
971: select displayed_field
972: into g_rate_type_dsp
973: from ap_lookup_codes
974: where lookup_type = 'APXINREV_RATE_TYPE'
975: and lookup_code = P_RATE_TYPE_LOOKUP_CODE;
976:
977: if P_RATE_TYPE_LOOKUP_CODE = 'PERIOD' then