APPS.AP_WEB_UPLOAD_PDM_PKG dependencies on OIE_POL_RATES_INTERFACE

Line 30: put_line('Clean up oie_pol_rates_interface');

26:
27: PROCEDURE CleanRatesInterface(p_ratetype IN VARCHAR2) IS
28: BEGIN
29: --
30: put_line('Clean up oie_pol_rates_interface');
31: --
32: delete
33: from oie_pol_rates_interface
34: where

Line 33: from oie_pol_rates_interface

29: --
30: put_line('Clean up oie_pol_rates_interface');
31: --
32: delete
33: from oie_pol_rates_interface
34: where
35: (
36: (p_ratetype = 'CONUS' and country = 'UNITED STATES' and state_province not in ('HAWAII', 'ALASKA'))
37: or

Line 1747: from oie_pol_rates_interface

1743: -- cursor to check if rates exist
1744: -------------------------------
1745: cursor rates_exist_cur is
1746: select 'Y' rates_exist
1747: from oie_pol_rates_interface
1748: where
1749: (
1750: (p_ratetype = 'CONUS' and country = 'UNITED STATES' and state_province not in ('HAWAII', 'ALASKA'))
1751: or

Line 1777: from oie_pol_rates_interface

1773: footnote_rate_amt,
1774: max_per_diem_amt,
1775: effective_date,
1776: '' as effective_end_date
1777: from oie_pol_rates_interface
1778: where
1779: (
1780: (p_ratetype = 'CONUS' and country = 'UNITED STATES' and state_province not in ('HAWAII', 'ALASKA'))
1781: or

Line 2571: from oie_pol_rates_interface

2567: -- cursor to check if rates exist
2568: -------------------------------
2569: cursor rates_exist_cur is
2570: select 'Y' rates_exist
2571: from oie_pol_rates_interface
2572: where
2573: (
2574: (p_ratetype = 'CONUS' and country = 'UNITED STATES' and state_province not in ('HAWAII', 'ALASKA'))
2575: or

Line 2601: from oie_pol_rates_interface

2597: footnote_rate_amt,
2598: max_per_diem_amt,
2599: effective_date,
2600: '' as effective_end_date
2601: from oie_pol_rates_interface
2602: where
2603: (
2604: (p_ratetype = 'CONUS' and country = 'UNITED STATES' and state_province not in ('HAWAII', 'ALASKA'))
2605: or