DBA Data[Home] [Help]

APPS.PAY_PYAUPYT_XMLP_PKG dependencies on PAY_AU_PAYTAX_PKG

Line 168: access the Global values in pay_au_paytax_pkg.get_tax function */

164: ELSE
165: CP_DGE := NULL;
166: END IF;
167: /* Bug 10069164 - Added code to check existence of record in FND_SESSIONS table in order to
168: access the Global values in pay_au_paytax_pkg.get_tax function */
169: OPEN C_SESSION;
170: FETCH C_SESSION INTO L_SESSION_FLAG;
171: IF C_SESSION%NOTFOUND THEN
172: INSERT INTO FND_SESSIONS (SESSION_ID, EFFECTIVE_DATE) VALUES (USERENV('SESSIONID'),TRUNC(P_START_DATE));

Line 236: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

232: BEGIN
233: IF (P_LEGAL_EMPLOYER_LP IS NOT NULL) THEN
234: IF (P_TAX_STATE_LP IS NOT NULL) THEN
235: IF (P_TAX_STATE_LP = 'ACT') THEN
236: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
237: ,CS_DGE_STATE
238: ,CS_DGE_GROUP_NAME
239: ,STATE_CODE
240: ,CS_STATE_TAXABLE_INCOME

Line 250: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

246: ,NVL(P_NSW_LP
247: ,-9999)));
248: END IF;
249: IF (P_TAX_STATE_LP = 'NSW') THEN
250: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
251: ,CS_DGE_STATE
252: ,CS_DGE_GROUP_NAME
253: ,STATE_CODE
254: ,CS_STATE_TAXABLE_INCOME

Line 264: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

260: ,NVL(P_NSW_LP
261: ,-9999)));
262: END IF;
263: IF (P_TAX_STATE_LP = 'VIC') THEN
264: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
265: ,CS_DGE_STATE
266: ,CS_DGE_GROUP_NAME
267: ,STATE_CODE
268: ,CS_STATE_TAXABLE_INCOME

Line 278: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

274: ,NVL(P_VIC_LP
275: ,-9999)));
276: END IF;
277: IF (P_TAX_STATE_LP = 'QLD') THEN
278: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
279: ,CS_DGE_STATE
280: ,CS_DGE_GROUP_NAME
281: ,STATE_CODE
282: ,CS_STATE_TAXABLE_INCOME

Line 292: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

288: ,NVL(P_QLD_LP
289: ,-9999)));
290: END IF;
291: IF (P_TAX_STATE_LP = 'SA') THEN
292: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
293: ,CS_DGE_STATE
294: ,CS_DGE_GROUP_NAME
295: ,STATE_CODE
296: ,CS_STATE_TAXABLE_INCOME

Line 306: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

302: ,NVL(P_SA_LP
303: ,-9999)));
304: END IF;
305: IF (P_TAX_STATE_LP = 'WA') THEN
306: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
307: ,CS_DGE_STATE
308: ,CS_DGE_GROUP_NAME
309: ,STATE_CODE
310: ,CS_STATE_TAXABLE_INCOME

Line 320: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

316: ,NVL(P_WA_LP
317: ,-9999)));
318: END IF;
319: IF (P_TAX_STATE_LP = 'TAS') THEN
320: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
321: ,CS_DGE_STATE
322: ,CS_DGE_GROUP_NAME
323: ,STATE_CODE
324: ,CS_STATE_TAXABLE_INCOME

Line 334: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

330: ,NVL(P_TAS_LP
331: ,-9999)));
332: END IF;
333: IF (P_TAX_STATE_LP = 'NT') THEN
334: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
335: ,CS_DGE_STATE
336: ,CS_DGE_GROUP_NAME
337: ,STATE_CODE
338: ,CS_STATE_TAXABLE_INCOME

Line 349: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

345: ,-9999)));
346: END IF;
347: ELSE
348: IF (STATE_CODE = 'ACT') THEN
349: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
350: ,CS_DGE_STATE
351: ,CS_DGE_GROUP_NAME
352: ,STATE_CODE
353: ,CS_STATE_TAXABLE_INCOME

Line 363: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

359: ,NVL(P_ACT_LP
360: ,-9999)));
361: END IF;
362: IF (STATE_CODE = 'NSW') THEN
363: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
364: ,CS_DGE_STATE
365: ,CS_DGE_GROUP_NAME
366: ,STATE_CODE
367: ,CS_STATE_TAXABLE_INCOME

Line 377: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

373: ,NVL(P_NSW_LP
374: ,-9999)));
375: END IF;
376: IF (STATE_CODE = 'VIC') THEN
377: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
378: ,CS_DGE_STATE
379: ,CS_DGE_GROUP_NAME
380: ,STATE_CODE
381: ,CS_STATE_TAXABLE_INCOME

Line 391: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

387: ,NVL(P_VIC_LP
388: ,-9999)));
389: END IF;
390: IF (STATE_CODE = 'QLD') THEN
391: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
392: ,CS_DGE_STATE
393: ,CS_DGE_GROUP_NAME
394: ,STATE_CODE
395: ,CS_STATE_TAXABLE_INCOME

Line 405: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

401: ,NVL(P_QLD_LP
402: ,-9999)));
403: END IF;
404: IF (STATE_CODE = 'SA') THEN
405: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
406: ,CS_DGE_STATE
407: ,CS_DGE_GROUP_NAME
408: ,STATE_CODE
409: ,CS_STATE_TAXABLE_INCOME

Line 419: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

415: ,NVL(P_SA_LP
416: ,-9999)));
417: END IF;
418: IF (STATE_CODE = 'WA') THEN
419: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
420: ,CS_DGE_STATE
421: ,CS_DGE_GROUP_NAME
422: ,STATE_CODE
423: ,CS_STATE_TAXABLE_INCOME

Line 433: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

429: ,NVL(P_WA_LP
430: ,-9999)));
431: END IF;
432: IF (STATE_CODE = 'TAS') THEN
433: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
434: ,CS_DGE_STATE
435: ,CS_DGE_GROUP_NAME
436: ,STATE_CODE
437: ,CS_STATE_TAXABLE_INCOME

Line 447: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES

443: ,NVL(P_TAS_LP
444: ,-9999)));
445: END IF;
446: IF (STATE_CODE = 'NT') THEN
447: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(NO_OF_STATES
448: ,CS_DGE_STATE
449: ,CS_DGE_GROUP_NAME
450: ,STATE_CODE
451: ,CS_STATE_TAXABLE_INCOME

Line 462: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(CS_NO_OF_STATES

458: ,-9999)));
459: END IF;
460: END IF;
461: ELSE
462: RETURN (PAY_AU_PAYTAX_PKG.GET_TAX(CS_NO_OF_STATES
463: ,CS_DGE_STATE
464: ,CS_DGE_GROUP_NAME
465: ,STATE_CODE
466: ,CS_STATE_TAXABLE_INCOME