APPS.AP_PAY_IN_FULL_PKG dependencies on AP_LOOKUP_CODES

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

1141: l_rate NUMBER;
1142: l_due_date DATE;
1143: l_int_invoice_days NUMBER;
1144: /* Datatype for following variables changed for MLS */
1145: l_nls_interest ap_lookup_codes.displayed_field%TYPE; -- **1**
1146: l_nls_days ap_lookup_codes.displayed_field%TYPE; -- **1**
1147: l_nls_percent ap_lookup_codes.displayed_field%TYPE; -- **1**
1148:
1149: BEGIN

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

1142: l_due_date DATE;
1143: l_int_invoice_days NUMBER;
1144: /* Datatype for following variables changed for MLS */
1145: l_nls_interest ap_lookup_codes.displayed_field%TYPE; -- **1**
1146: l_nls_days ap_lookup_codes.displayed_field%TYPE; -- **1**
1147: l_nls_percent ap_lookup_codes.displayed_field%TYPE; -- **1**
1148:
1149: BEGIN
1150: -- Get the Translatable Words for filling the description

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

1143: l_int_invoice_days NUMBER;
1144: /* Datatype for following variables changed for MLS */
1145: l_nls_interest ap_lookup_codes.displayed_field%TYPE; -- **1**
1146: l_nls_days ap_lookup_codes.displayed_field%TYPE; -- **1**
1147: l_nls_percent ap_lookup_codes.displayed_field%TYPE; -- **1**
1148:
1149: BEGIN
1150: -- Get the Translatable Words for filling the description
1151: SELECT l1.displayed_field,

Line 1157: FROM ap_lookup_codes l1,

1153: l3.displayed_field
1154: INTO l_nls_interest,
1155: l_nls_days,
1156: l_nls_percent
1157: FROM ap_lookup_codes l1,
1158: ap_lookup_codes l2,
1159: ap_lookup_codes l3
1160: WHERE l1.lookup_type = 'NLS TRANSLATION'
1161: AND l1.lookup_code = 'INTEREST'

Line 1158: ap_lookup_codes l2,

1154: INTO l_nls_interest,
1155: l_nls_days,
1156: l_nls_percent
1157: FROM ap_lookup_codes l1,
1158: ap_lookup_codes l2,
1159: ap_lookup_codes l3
1160: WHERE l1.lookup_type = 'NLS TRANSLATION'
1161: AND l1.lookup_code = 'INTEREST'
1162: AND l2.lookup_type = 'NLS TRANSLATION'

Line 1159: ap_lookup_codes l3

1155: l_nls_days,
1156: l_nls_percent
1157: FROM ap_lookup_codes l1,
1158: ap_lookup_codes l2,
1159: ap_lookup_codes l3
1160: WHERE l1.lookup_type = 'NLS TRANSLATION'
1161: AND l1.lookup_code = 'INTEREST'
1162: AND l2.lookup_type = 'NLS TRANSLATION'
1163: AND l2.lookup_code = 'DAYS'