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));
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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