APPS.PA_PAXPRTSK_XMLP_PKG dependencies on PA_LOOKUPS

Line 148: PA_LOOKUPS

144: SELECT
145: MEANING
146: INTO MESSAGE_NAME
147: FROM
148: PA_LOOKUPS
149: WHERE LOOKUP_TYPE = 'MESSAGE'
150: AND LOOKUP_CODE = 'NO_DATA_FOUND';
151: C_NO_DATA_FOUND := SUBSTR(MESSAGE_NAME,4,14);
152: RETURN (TRUE);

Line 242: L_REASON PA_LOOKUPS.MEANING%TYPE;

238: RETURN (TRUE);
239: END G_EMP_BILL_RATESGROUPFILTER;
240:
241: FUNCTION CF_JOB_REASONFORMULA(JOB_DISC_REASON IN VARCHAR2) RETURN CHAR IS
242: L_REASON PA_LOOKUPS.MEANING%TYPE;
243: BEGIN
244: SELECT
245: MEANING
246: INTO L_REASON

Line 248: PA_LOOKUPS

244: SELECT
245: MEANING
246: INTO L_REASON
247: FROM
248: PA_LOOKUPS
249: WHERE LOOKUP_TYPE = 'RATE AND DISCOUNT REASON'
250: AND LOOKUP_CODE = JOB_DISC_REASON;
251: RETURN (L_REASON);
252: EXCEPTION

Line 259: L_REASON PA_LOOKUPS.MEANING%TYPE;

255: RETURN (L_REASON);
256: END CF_JOB_REASONFORMULA;
257:
258: FUNCTION CF_NL_REASONFORMULA(NL_DISC_REASON IN VARCHAR2) RETURN CHAR IS
259: L_REASON PA_LOOKUPS.MEANING%TYPE;
260: BEGIN
261: SELECT
262: MEANING
263: INTO L_REASON

Line 265: PA_LOOKUPS

261: SELECT
262: MEANING
263: INTO L_REASON
264: FROM
265: PA_LOOKUPS
266: WHERE LOOKUP_TYPE = 'RATE AND DISCOUNT REASON'
267: AND LOOKUP_CODE = NL_DISC_REASON;
268: RETURN (L_REASON);
269: EXCEPTION

Line 276: L_REASON PA_LOOKUPS.MEANING%TYPE;

272: RETURN (L_REASON);
273: END CF_NL_REASONFORMULA;
274:
275: FUNCTION CF_EMP_REASONFORMULA(RATE_DISC_REASON_CODE IN VARCHAR2) RETURN CHAR IS
276: L_REASON PA_LOOKUPS.MEANING%TYPE;
277: BEGIN
278: SELECT
279: MEANING
280: INTO L_REASON

Line 282: PA_LOOKUPS

278: SELECT
279: MEANING
280: INTO L_REASON
281: FROM
282: PA_LOOKUPS
283: WHERE LOOKUP_TYPE = 'RATE AND DISCOUNT REASON'
284: AND LOOKUP_CODE = RATE_DISC_REASON_CODE;
285: RETURN (L_REASON);
286: EXCEPTION

Line 301: PA_LOOKUPS LKP,

297: SELECT
298: MEANING
299: INTO TMP_FLAG
300: FROM
301: PA_LOOKUPS LKP,
302: PA_PROJECTS PRJ
303: WHERE LKP.LOOKUP_TYPE = 'REVENUE ACCRUAL METHOD'
304: AND LKP.LOOKUP_CODE = PRJ.REVENUE_ACCRUAL_METHOD
305: AND PRJ.PROJECT_ID = PROJECT_ID1;

Line 324: PA_LOOKUPS LKP,

320: SELECT
321: MEANING
322: INTO TMP_FLAG
323: FROM
324: PA_LOOKUPS LKP,
325: PA_PROJECTS PRJ
326: WHERE LKP.LOOKUP_TYPE = 'INVOICE METHOD'
327: AND LKP.LOOKUP_CODE = PRJ.INVOICE_METHOD
328: AND PRJ.PROJECT_ID = PROJECT_ID1;