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 1725: from oie_pol_rates_interface

1721: -- cursor to check if rates exist
1722: -------------------------------
1723: cursor rates_exist_cur is
1724: select 'Y' rates_exist
1725: from oie_pol_rates_interface
1726: where
1727: (
1728: (p_ratetype = 'CONUS' and country = 'UNITED STATES' and state_province not in ('HAWAII', 'ALASKA'))
1729: or

Line 1755: from oie_pol_rates_interface

1751: footnote_rate_amt,
1752: max_per_diem_amt,
1753: effective_date,
1754: '' as effective_end_date
1755: from oie_pol_rates_interface
1756: where
1757: (
1758: (p_ratetype = 'CONUS' and country = 'UNITED STATES' and state_province not in ('HAWAII', 'ALASKA'))
1759: or

Line 2542: from oie_pol_rates_interface

2538: -- cursor to check if rates exist
2539: -------------------------------
2540: cursor rates_exist_cur is
2541: select 'Y' rates_exist
2542: from oie_pol_rates_interface
2543: where
2544: (
2545: (p_ratetype = 'CONUS' and country = 'UNITED STATES' and state_province not in ('HAWAII', 'ALASKA'))
2546: or

Line 2572: from oie_pol_rates_interface

2568: footnote_rate_amt,
2569: max_per_diem_amt,
2570: effective_date,
2571: '' as effective_end_date
2572: from oie_pol_rates_interface
2573: where
2574: (
2575: (p_ratetype = 'CONUS' and country = 'UNITED STATES' and state_province not in ('HAWAII', 'ALASKA'))
2576: or