APPS.PAY_IN_ELEMENT_TEMPLATE_PKG dependencies on FND_CURRENCIES

Line 476: l_enabled_flag fnd_currencies.enabled_flag%TYPE;

472: l_effective_date CONSTANT DATE := TO_DATE('01/04/2005','DD/MM/YYYY');
473:
474: l_template_exists VARCHAR2(1);
475: l_template_id pay_element_templates.template_id%TYPE;
476: l_enabled_flag fnd_currencies.enabled_flag%TYPE;
477: l_object_version_number NUMBER ;
478: l_template_rec pay_in_etw_struct.t_template_setup_rec;
479: l_sequence NUMBER;
480: l_db_items_flag VARCHAR2(1);

Line 538: FROM fnd_currencies

534: END IF;
535:
536: SELECT enabled_flag
537: INTO l_enabled_flag
538: FROM fnd_currencies
539: WHERE currency_code = pay_in_etw_struct.g_currency_code;
540:
541: UPDATE fnd_currencies
542: SET enabled_flag = 'Y'

Line 541: UPDATE fnd_currencies

537: INTO l_enabled_flag
538: FROM fnd_currencies
539: WHERE currency_code = pay_in_etw_struct.g_currency_code;
540:
541: UPDATE fnd_currencies
542: SET enabled_flag = 'Y'
543: WHERE currency_code = pay_in_etw_struct.g_currency_code
544: AND enabled_flag <> 'Y';
545:

Line 1021: UPDATE fnd_currencies

1017: END LOOP;
1018:
1019: pay_in_utils.set_location(g_debug,l_procedure,340);
1020:
1021: UPDATE fnd_currencies
1022: SET enabled_flag = l_enabled_flag
1023: WHERE currency_code = pay_in_etw_struct.g_currency_code;
1024:
1025: --