APPS.AP_WEB_PAYMENTS_PKG dependencies on AP_LOOKUP_CODES

Line 16: method_trans ap_lookup_codes.displayed_field%TYPE);

12: invoice_id ap_invoices.invoice_id%TYPE,
13: gl_date ap_invoice_payments.accounting_date%TYPE,
14: type ap_invoice_payments.invoice_payment_type%TYPE,
15: method ap_checks.payment_method_lookup_code%TYPE,
16: method_trans ap_lookup_codes.displayed_field%TYPE);
17:
18: -----------------------------------------------------------------------
19: -- Declare generic cursor to get check number, check id, invoice number
20: -- invoice id, payment type, payment method lookup code, and translated

Line 37: ap_lookup_codes alc2

33: alc2.displayed_field
34: FROM ap_invoice_payments aip,
35: ap_checks ac,
36: ap_invoices ai,
37: ap_lookup_codes alc2
38: WHERE aip.invoice_id = l_invoice_id
39: AND aip.payment_num = l_payment_num
40: AND aip.check_id = ac.check_id
41: AND aip.other_invoice_id = ai.invoice_id (+)

Line 57: ap_lookup_codes alc2,

53: alc2.displayed_field
54: FROM ap_invoice_payments aip,
55: ap_checks ac,
56: ap_invoices ai,
57: ap_lookup_codes alc2,
58: ap_invoice_lines ail1,
59: ap_invoice_lines ail2,
60: ap_invoice_distributions aid1,
61: ap_invoice_distributions aid2

Line 87: type_trans ap_lookup_codes.displayed_field%TYPE;

83: FUNCTION concat_document_num_type(l_payment_record IN PAYMENT_RECORD)
84: RETURN VARCHAR2
85: IS
86: l_paid_by VARCHAR2(80);
87: type_trans ap_lookup_codes.displayed_field%TYPE;
88: BEGIN
89:
90: IF (l_payment_record.type = 'PREPAY') THEN
91:

Line 94: FROM ap_lookup_codes

90: IF (l_payment_record.type = 'PREPAY') THEN
91:
92: SELECT displayed_field
93: INTO type_trans
94: FROM ap_lookup_codes
95: WHERE lookup_type = 'NLS TRANSLATION'
96: AND lookup_code = 'PREPAY';
97:
98: -------------------------------------------------------