DBA Data[Home] [Help]

APPS.PY_ZA_TX_01032012 dependencies on DUAL

Line 415: FROM dual;

411: -- Calculate the Current Effective Calendar Month to Date Start Date
412: --
413: SELECT trunc(dbi_SES_DTE,'Month')
414: INTO nti_CurMthStrtDte
415: FROM dual;
416: hr_utility.set_location('py_za_tx_01032012.NetTxbIncCalc',2);
417:
418: -- Calculate the Current Effective Calendar Month to Date End Date
419: --

Line 422: FROM dual;

418: -- Calculate the Current Effective Calendar Month to Date End Date
419: --
420: SELECT last_day(dbi_SES_DTE)
421: INTO nti_CurMthEndDte
422: FROM dual;
423: hr_utility.set_location('py_za_tx_01032012.NetTxbIncCalc',3);
424:
425: -- Calculate Site Factor
426: --

Line 7727: -- Where individual balances were not present

7723: trc_TotLibPO_Upd :=0;
7724:
7725: -- Bug 13777759
7726: -- To handle the Medical Tax Credit previous implementation
7727: -- Where individual balances were not present
7728: p_MedCrUsed := 0;
7729:
7730: l_MdTxCrdtUDR_Adj := 0;
7731: l_MdTxCrdtUNi_Adj := 0;