DBA Data[Home] [Help]

APPS.PA_PARCPRJR_XMLP_PKG dependencies on PA_LOOKUPS

Line 162: L_SELECTION_OPTION PA_LOOKUPS.MEANING%TYPE := NULL;

158: RETURN L_MEANING;
159: END CF_REFRESHFORMULA;
160:
161: FUNCTION CF_SELECTION_OPTIONFORMULA RETURN CHAR IS
162: L_SELECTION_OPTION PA_LOOKUPS.MEANING%TYPE := NULL;
163: BEGIN
164: IF P_SELECTION_OPTION IS NOT NULL THEN
165: SELECT
166: MEANING

Line 169: PA_LOOKUPS

165: SELECT
166: MEANING
167: INTO L_SELECTION_OPTION
168: FROM
169: PA_LOOKUPS
170: WHERE LOOKUP_TYPE = 'PA_RES_PULL_SELECT_TYPE'
171: AND LOOKUP_CODE = P_SELECTION_OPTION;
172: END IF;
173: RETURN L_SELECTION_OPTION;

Line 217: L_PULL_TERM_RES PA_LOOKUPS.MEANING%TYPE := NULL;

213: RETURN L_START_ORG_ID;
214: END CF_START_ORG_IDFORMULA;
215:
216: FUNCTION CF_PULL_TERM_RESFORMULA RETURN CHAR IS
217: L_PULL_TERM_RES PA_LOOKUPS.MEANING%TYPE := NULL;
218: BEGIN
219: IF P_PULL_TERM_RES IS NOT NULL THEN
220: SELECT
221: MEANING

Line 224: PA_LOOKUPS

220: SELECT
221: MEANING
222: INTO L_PULL_TERM_RES
223: FROM
224: PA_LOOKUPS
225: WHERE LOOKUP_TYPE = 'YES_NO'
226: AND LOOKUP_CODE = P_PULL_TERM_RES;
227: END IF;
228: RETURN L_PULL_TERM_RES;