DBA Data[Home] [Help]

APPS.AP_APXINAGE_XMLP_PKG dependencies on FND_LOOKUPS

Line 62: FROM FND_LOOKUPS

58: BEGIN
59: IF (P_SUMMARY_OPTION is not NULL) then
60: SELECT Meaning
61: INTO C_HEAD_SUMMARY_OPTION
62: FROM FND_LOOKUPS
63: WHERE lookup_code = P_SUMMARY_OPTION
64: AND lookup_type = 'YES_NO';
65: END IF;
66:

Line 72: FROM FND_LOOKUPS

68: BEGIN
69: IF (P_FORMAT_OPTION is not NULL) then
70: SELECT Meaning
71: INTO C_HEAD_FORMAT_OPTION
72: FROM FND_LOOKUPS
73: WHERE lookup_code = P_FORMAT_OPTION
74: AND lookup_type = 'YES_NO';
75: END IF;
76: END;

Line 156: nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;

152:
153: END;
154:
155: FUNCTION get_nls_strings RETURN BOOLEAN IS
156: nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;
157: BEGIN
158:
159: nls_all := '';
160: nls_yes := '';

Line 167: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la

163: SELECT ly.meaning,
164: ln.meaning,
165: la.displayed_field
166: INTO nls_yes, nls_no, nls_all
167: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la
168: WHERE ly.lookup_type = 'YES_NO'
169: AND ly.lookup_code = 'Y'
170: AND ln.lookup_type = 'YES_NO'
171: AND ln.lookup_code = 'N'