APPS.JL_JLZZPSSR_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 67: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

63: RETURN (FALSE);
64: END GET_COVER_PAGE_VALUES;
65:
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;

Line 68: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

64: END GET_COVER_PAGE_VALUES;
65:
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

Line 69: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

65:
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

Line 83: AP_LOOKUP_CODES L1,

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'
87: AND LY.LOOKUP_CODE = 'Y'

Line 84: AP_LOOKUP_CODES L2,

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'
87: AND LY.LOOKUP_CODE = 'Y'
88: AND LN.LOOKUP_TYPE = 'YES_NO'

Line 85: AP_LOOKUP_CODES L3

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'
87: AND LY.LOOKUP_CODE = 'Y'
88: AND LN.LOOKUP_TYPE = 'YES_NO'
89: AND LN.LOOKUP_CODE = 'N'