DBA Data[Home] [Help]

APPS.PQH_EFC dependencies on HR_CURRENCY_PKG

Line 522: hr_currency_pkg.convert_amount

518:
519: IF ( p_column_no = 1 AND l_unit1_type = 'MONEY' ) THEN
520: -- convert
521: l_converted_amt :=
522: hr_currency_pkg.convert_amount
523: ( p_from_currency => l_existing_curr_cd,
524: p_to_currency => 'EUR',
525: p_conversion_date => sysdate,
526: p_amount => NVL(p_unit_value,0),

Line 533: hr_currency_pkg.convert_amount

529:
530: ELSIF ( p_column_no = 1 AND l_unit1_type = 'M' ) THEN
531: -- convert
532: l_converted_amt :=
533: hr_currency_pkg.convert_amount
534: ( p_from_currency => l_existing_curr_cd,
535: p_to_currency => 'EUR',
536: p_conversion_date => sysdate,
537: p_amount => NVL(p_unit_value,0),

Line 544: hr_currency_pkg.convert_amount

540:
541: ELSIF ( p_column_no = 1 AND p_entity_cd = 'SSL' AND l_unit1_type = 'MONEY_VALUE') THEN
542: -- convert for stock columns
543: l_converted_amt :=
544: hr_currency_pkg.convert_amount
545: ( p_from_currency => l_existing_curr_cd,
546: p_to_currency => 'EUR',
547: p_conversion_date => sysdate,
548: p_amount => NVL(p_unit_value,0),

Line 554: hr_currency_pkg.convert_amount

550: );
551: ELSIF ( p_column_no = 2 AND p_entity_cd = 'SSL' ) THEN
552: -- convert for monetary columns
553: l_converted_amt :=
554: hr_currency_pkg.convert_amount
555: ( p_from_currency => l_existing_curr_cd,
556: p_to_currency => 'EUR',
557: p_conversion_date => sysdate,
558: p_amount => NVL(p_unit_value,0),

Line 564: hr_currency_pkg.convert_amount

560: );
561: ELSIF ( p_column_no = 2 AND l_unit2_type = 'MONEY' ) THEN
562: -- convert
563: l_converted_amt :=
564: hr_currency_pkg.convert_amount
565: ( p_from_currency => l_existing_curr_cd,
566: p_to_currency => 'EUR',
567: p_conversion_date => sysdate,
568: p_amount => NVL(p_unit_value,0),

Line 575: hr_currency_pkg.convert_amount

571:
572: ELSIF ( p_column_no = 3 AND l_unit3_type = 'MONEY' ) THEN
573: -- convert
574: l_converted_amt :=
575: hr_currency_pkg.convert_amount
576: ( p_from_currency => l_existing_curr_cd,
577: p_to_currency => 'EUR',
578: p_conversion_date => sysdate,
579: p_amount => NVL(p_unit_value,0),

Line 585: hr_currency_pkg.convert_amount

581: );
582: ELSIF ( p_entity_cd = 'PEC' ) THEN
583: -- convert
584: l_converted_amt :=
585: hr_currency_pkg.convert_amount
586: ( p_from_currency => l_existing_curr_cd,
587: p_to_currency => 'EUR',
588: p_conversion_date => sysdate,
589: p_amount => NVL(p_unit_value,0),

Line 595: hr_currency_pkg.convert_amount

591: );
592: ELSIF ( p_entity_cd = 'BRE' AND l_unit1_type = 'MONEY' ) THEN
593: -- convert
594: l_converted_amt :=
595: hr_currency_pkg.convert_amount
596: ( p_from_currency => l_existing_curr_cd,
597: p_to_currency => 'EUR',
598: p_conversion_date => sysdate,
599: p_amount => NVL(p_unit_value,0),