DBA Data[Home] [Help]

APPS.AP_PAY_IN_FULL_PKG dependencies on AP_LOOKUP_CODES

Line 1324: l_nls_interest ap_lookup_codes.displayed_field%TYPE; -- **1**

1320: l_rate NUMBER;
1321: l_due_date DATE;
1322: l_int_invoice_days NUMBER;
1323: /* Datatype for following variables changed for MLS */
1324: l_nls_interest ap_lookup_codes.displayed_field%TYPE; -- **1**
1325: l_nls_days ap_lookup_codes.displayed_field%TYPE; -- **1**
1326: l_nls_percent ap_lookup_codes.displayed_field%TYPE; -- **1**
1327:
1328: BEGIN

Line 1325: l_nls_days ap_lookup_codes.displayed_field%TYPE; -- **1**

1321: l_due_date DATE;
1322: l_int_invoice_days NUMBER;
1323: /* Datatype for following variables changed for MLS */
1324: l_nls_interest ap_lookup_codes.displayed_field%TYPE; -- **1**
1325: l_nls_days ap_lookup_codes.displayed_field%TYPE; -- **1**
1326: l_nls_percent ap_lookup_codes.displayed_field%TYPE; -- **1**
1327:
1328: BEGIN
1329: -- Get the Translatable Words for filling the description

Line 1326: l_nls_percent ap_lookup_codes.displayed_field%TYPE; -- **1**

1322: l_int_invoice_days NUMBER;
1323: /* Datatype for following variables changed for MLS */
1324: l_nls_interest ap_lookup_codes.displayed_field%TYPE; -- **1**
1325: l_nls_days ap_lookup_codes.displayed_field%TYPE; -- **1**
1326: l_nls_percent ap_lookup_codes.displayed_field%TYPE; -- **1**
1327:
1328: BEGIN
1329: -- Get the Translatable Words for filling the description
1330: SELECT l1.displayed_field,

Line 1336: FROM ap_lookup_codes l1,

1332: l3.displayed_field
1333: INTO l_nls_interest,
1334: l_nls_days,
1335: l_nls_percent
1336: FROM ap_lookup_codes l1,
1337: ap_lookup_codes l2,
1338: ap_lookup_codes l3
1339: WHERE l1.lookup_type = 'NLS TRANSLATION'
1340: AND l1.lookup_code = 'INTEREST'

Line 1337: ap_lookup_codes l2,

1333: INTO l_nls_interest,
1334: l_nls_days,
1335: l_nls_percent
1336: FROM ap_lookup_codes l1,
1337: ap_lookup_codes l2,
1338: ap_lookup_codes l3
1339: WHERE l1.lookup_type = 'NLS TRANSLATION'
1340: AND l1.lookup_code = 'INTEREST'
1341: AND l2.lookup_type = 'NLS TRANSLATION'

Line 1338: ap_lookup_codes l3

1334: l_nls_days,
1335: l_nls_percent
1336: FROM ap_lookup_codes l1,
1337: ap_lookup_codes l2,
1338: ap_lookup_codes l3
1339: WHERE l1.lookup_type = 'NLS TRANSLATION'
1340: AND l1.lookup_code = 'INTEREST'
1341: AND l2.lookup_type = 'NLS TRANSLATION'
1342: AND l2.lookup_code = 'DAYS'