APPS.JL_JLZZPSSR_XMLP_PKG dependencies on FND_LOOKUPS

Line 70: NLS_YES FND_LOOKUPS.MEANING%TYPE;

66: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
67: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
68: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
69: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
70: NLS_YES FND_LOOKUPS.MEANING%TYPE;
71: NLS_NO FND_LOOKUPS.MEANING%TYPE;
72: BEGIN
73: SELECT
74: LY.MEANING,

Line 71: NLS_NO FND_LOOKUPS.MEANING%TYPE;

67: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
68: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
69: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
70: NLS_YES FND_LOOKUPS.MEANING%TYPE;
71: NLS_NO FND_LOOKUPS.MEANING%TYPE;
72: BEGIN
73: SELECT
74: LY.MEANING,
75: LN.MEANING,

Line 81: FND_LOOKUPS LY,

77: L2.DISPLAYED_FIELD,
78: L3.DISPLAYED_FIELD
79: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
80: FROM
81: FND_LOOKUPS LY,
82: FND_LOOKUPS LN,
83: AP_LOOKUP_CODES L1,
84: AP_LOOKUP_CODES L2,
85: AP_LOOKUP_CODES L3

Line 82: FND_LOOKUPS LN,

78: L3.DISPLAYED_FIELD
79: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
80: FROM
81: FND_LOOKUPS LY,
82: FND_LOOKUPS LN,
83: AP_LOOKUP_CODES L1,
84: AP_LOOKUP_CODES L2,
85: AP_LOOKUP_CODES L3
86: WHERE LY.LOOKUP_TYPE = 'YES_NO'

Line 259: FND_LOOKUPS L

255: SELECT
256: L.MEANING
257: INTO V_TRANS_TYPE
258: FROM
259: FND_LOOKUPS L
260: WHERE L.LOOKUP_CODE = 'PMT'
261: AND L.LOOKUP_TYPE = 'JLZZ_SUPPLIER_TRX_TYPE'
262: AND NVL(L.START_DATE_ACTIVE
263: ,SYSDATE) <= sysdate

Line 285: FND_LOOKUPS L

281: SELECT
282: L.MEANING
283: INTO V_TRANS_TYPE
284: FROM
285: FND_LOOKUPS L
286: WHERE L.LOOKUP_CODE = 'INV'
287: AND L.LOOKUP_TYPE = 'JLZZ_SUPPLIER_TRX_TYPE'
288: AND NVL(L.START_DATE_ACTIVE
289: ,SYSDATE) <= sysdate