APPS.PAY_AE_ELEMENT_TEMPLATE_PKG dependencies on FND_CURRENCIES

Line 4444: l_enabled_flag FND_CURRENCIES.ENABLED_FLAG%TYPE;

4440: ------------------------------------------------------------------------
4441: ------------------------------------------------------------------------
4442: PROCEDURE create_templates IS
4443:
4444: l_enabled_flag FND_CURRENCIES.ENABLED_FLAG%TYPE;
4445: CURSOR csr_get_currency IS
4446: SELECT enabled_flag
4447: FROM fnd_currencies
4448: WHERE currency_code = 'AED';

Line 4447: FROM fnd_currencies

4443:
4444: l_enabled_flag FND_CURRENCIES.ENABLED_FLAG%TYPE;
4445: CURSOR csr_get_currency IS
4446: SELECT enabled_flag
4447: FROM fnd_currencies
4448: WHERE currency_code = 'AED';
4449:
4450: BEGIN
4451: OPEN csr_get_currency;

Line 4456: UPDATE fnd_currencies

4452: FETCH csr_get_currency INTO l_enabled_flag;
4453: CLOSE csr_get_currency;
4454:
4455: /* Enable AED Currency */
4456: UPDATE fnd_currencies
4457: SET enabled_flag = 'Y'
4458: WHERE currency_code = 'AED'
4459: AND enabled_flag <> 'Y';
4460:

Line 4485: UPDATE fnd_currencies

4481: create_ot_allw_template;
4482:
4483: create_unp_leave_dedn_template;
4484:
4485: UPDATE fnd_currencies
4486: SET enabled_flag = l_enabled_flag
4487: WHERE currency_code = 'AED';
4488:
4489: END create_templates;