APPS.HR_PPVOL dependencies on GL_DAILY_RATES

Line 18: tbattoo 09-APR-1999 - changed pay_exchange_rates to use gl_daily_rates

14: to pay_org_payment_methods_f in CASE.
15: amills 06-DEC-1995 - Changed all date referencing to DDMMYYYY format
16: so that it can be translated.
17: WMcVeagh 19-MAR-1998 - Change create or replace 'as' not 'is'
18: tbattoo 09-APR-1999 - changed pay_exchange_rates to use gl_daily_rates
19: alogue 04-JUN-2001 - amend reference to gl_daily_rates to
20: utilise an index.
21: mreid 03-OCT-2002 - Ensured call to create_balance_type passed params
22: pgongada 25-NOV-2005 - Changed the ins_pmu function. Added dbdrv lines.

Line 19: alogue 04-JUN-2001 - amend reference to gl_daily_rates to

15: amills 06-DEC-1995 - Changed all date referencing to DDMMYYYY format
16: so that it can be translated.
17: WMcVeagh 19-MAR-1998 - Change create or replace 'as' not 'is'
18: tbattoo 09-APR-1999 - changed pay_exchange_rates to use gl_daily_rates
19: alogue 04-JUN-2001 - amend reference to gl_daily_rates to
20: utilise an index.
21: mreid 03-OCT-2002 - Ensured call to create_balance_type passed params
22: pgongada 25-NOV-2005 - Changed the ins_pmu function. Added dbdrv lines.
23: */

Line 420: insert into gl_daily_rates_interface

416: inverse_rate in number) return number is
417: exchange_rate number(16);
418: begin
419:
420: insert into gl_daily_rates_interface
421: (from_currency,
422: to_currency,
423: from_conversion_date,
424: to_conversion_date,

Line 938: from gl_daily_rates

934:
935: begin
936: select count(*)
937: into dummy
938: from gl_daily_rates
939: where conversion_type = 'Payroll'
940: and from_currency = 'NVS'
941: and to_currency = 'GBP';
942: