DBA Data[Home] [Help]

APPS.PQH_SS_PRINT dependencies on FND_CURRENCIES

Line 344: l_currency fnd_currencies.description%Type;

340: And ppb.input_value_id = pivf.input_value_id
341: AND pivf.element_type_id = petf.element_type_id;
342:
343: l_currency_code pay_element_types_f.input_currency_code%Type;
344: l_currency fnd_currencies.description%Type;
345:
346: BEGIN
347:
348: IF p_pay_basis_id IS not null Then

Line 520: fnd_currencies_vl

516: CURSOR csr_get_currency IS
517: SELECT
518: description
519: FROM
520: fnd_currencies_vl
521: WHERE
522: enabled_flag = 'Y'
523: AND currency_code = p_currency_code
524: AND currency_flag = 'Y'

Line 528: l_meaning fnd_currencies.description%type := null;

524: AND currency_flag = 'Y'
525: AND sysdate >= NVL(start_date_active, sysdate)
526: AND sysdate <= NVL(end_date_active, sysdate);
527:
528: l_meaning fnd_currencies.description%type := null;
529:
530: BEGIN
531:
532: OPEN csr_get_currency;