eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_HEADERS

Line 163: p_policy_id IN ap_pol_headers.policy_id%TYPE,

159: -- Delcare the private method upfront so that it can be used
160: -- before the definition.
161:
162: PROCEDURE permutatePolicyLines(p_user_id IN NUMBER,
163: p_policy_id IN ap_pol_headers.policy_id%TYPE,
164: p_rate_type IN ap_pol_schedule_options.rate_type_code%TYPE);
165:
166: PROCEDURE permutateAddonRates( p_user_id IN NUMBER,
167: p_policy_id IN ap_pol_headers.policy_id%TYPE,

Line 167: p_policy_id IN ap_pol_headers.policy_id%TYPE,

163: p_policy_id IN ap_pol_headers.policy_id%TYPE,
164: p_rate_type IN ap_pol_schedule_options.rate_type_code%TYPE);
165:
166: PROCEDURE permutateAddonRates( p_user_id IN NUMBER,
167: p_policy_id IN ap_pol_headers.policy_id%TYPE,
168: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );
169:
170: PROCEDURE permutateNightRates( p_user_id IN NUMBER,
171: p_policy_id IN ap_pol_headers.policy_id%TYPE,

Line 171: p_policy_id IN ap_pol_headers.policy_id%TYPE,

167: p_policy_id IN ap_pol_headers.policy_id%TYPE,
168: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );
169:
170: PROCEDURE permutateNightRates( p_user_id IN NUMBER,
171: p_policy_id IN ap_pol_headers.policy_id%TYPE,
172: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );
173:
174: PROCEDURE permutateConusLines( p_user_id IN NUMBER,
175: p_policy_id IN ap_pol_headers.policy_id%TYPE);

Line 175: p_policy_id IN ap_pol_headers.policy_id%TYPE);

171: p_policy_id IN ap_pol_headers.policy_id%TYPE,
172: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE );
173:
174: PROCEDURE permutateConusLines( p_user_id IN NUMBER,
175: p_policy_id IN ap_pol_headers.policy_id%TYPE);
176:
177: FUNCTION get_hash_value(p_component1 IN VARCHAR2,
178: p_component2 IN VARCHAR2,
179: p_component3 IN VARCHAR2) RETURN NUMBER;

Line 205: l_sch_end_date ap_pol_headers.end_date%TYPE;

201: FUNCTION get_schedule_status(p_policy_id IN NUMBER) RETURN VARCHAR2 IS
202:
203: l_meaning fnd_lookups.meaning%TYPE := '';
204: l_lookup_code fnd_lookups.lookup_code%TYPE;
205: l_sch_end_date ap_pol_headers.end_date%TYPE;
206: l_no__saved_or_duplicated NUMBER;
207: l_no__active_or_inactive NUMBER;
208: l_no__need_activation NUMBER;
209:

Line 216: FROM ap_pol_headers

212: IF p_policy_id IS NOT NULL THEN
213:
214: SELECT end_date
215: INTO l_sch_end_date
216: FROM ap_pol_headers
217: WHERE policy_id = p_policy_id;
218:
219: -- Bug # 7132415
220: IF ( l_sch_end_date IS NOT NULL ) AND ( l_sch_end_date +

Line 920: from ap_pol_headers ph,

916:
917: CURSOR policy_cur IS
918: select ph.role_code,
919: pl.role_id
920: from ap_pol_headers ph,
921: ap_pol_lines pl
922: where pl.policy_id = ph.policy_id
923: and pl.policy_line_id = p_policy_line_id;
924:

Line 967: from ap_pol_headers ph,

963:
964: CURSOR policy_cur IS
965: select ph.role_code,
966: pso.role_id
967: from ap_pol_headers ph,
968: ap_pol_schedule_options pso
969: where ph.policy_id = pso.policy_id
970: and pso.schedule_option_id = p_policy_schedule_option_id;
971:

Line 1294: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,

1290: | Date Author Description of Changes
1291: | 16-May-2002 R Langi Created
1292: |
1293: *=======================================================================*/
1294: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,
1295: p_threshold IN ap_pol_schedule_options.threshold%TYPE) RETURN ap_pol_schedule_options.threshold%TYPE IS
1296: BEGIN
1297:
1298: RETURN getHighEndOfThreshold(p_policy_id, p_threshold, 'STANDARD');

Line 1321: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,

1317: | Date Author Description of Changes
1318: | 01-Nov-2005 krmenon Created
1319: |
1320: *=======================================================================*/
1321: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,
1322: p_threshold IN ap_pol_schedule_options.threshold%TYPE,
1323: p_rate_type IN ap_pol_schedule_options.rate_type_code%TYPE) RETURN ap_pol_schedule_options.threshold%TYPE IS
1324:
1325: CURSOR c_threshold IS

Line 1406: FUNCTION getPolicyCategoryCode(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN ap_pol_headers.category_code%TYPE IS

1402: | Date Author Description of Changes
1403: | 16-May-2002 R Langi Created
1404: |
1405: *=======================================================================*/
1406: FUNCTION getPolicyCategoryCode(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN ap_pol_headers.category_code%TYPE IS
1407:
1408: l_category_code ap_pol_headers.category_code%TYPE;
1409:
1410: BEGIN

Line 1408: l_category_code ap_pol_headers.category_code%TYPE;

1404: |
1405: *=======================================================================*/
1406: FUNCTION getPolicyCategoryCode(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN ap_pol_headers.category_code%TYPE IS
1407:
1408: l_category_code ap_pol_headers.category_code%TYPE;
1409:
1410: BEGIN
1411:
1412: IF pg_category_rec.EXISTS(p_policy_id) THEN

Line 1417: from ap_pol_headers

1413: l_category_code := pg_category_rec(p_policy_id);
1414: ELSE
1415: select category_code
1416: into l_category_code
1417: from ap_pol_headers
1418: where policy_id = p_policy_id;
1419:
1420: pg_category_rec(p_policy_id) := l_category_code;
1421: END IF;

Line 1462: FUNCTION checkRuleOption(p_policy_id IN ap_pol_headers.policy_id%TYPE,

1458: | Date Author Description of Changes
1459: | 16-May-2002 R Langi Created
1460: |
1461: *=======================================================================*/
1462: FUNCTION checkRuleOption(p_policy_id IN ap_pol_headers.policy_id%TYPE,
1463: p_rule IN VARCHAR2) RETURN VARCHAR2 IS
1464:
1465:
1466: FUNCTION isLocationEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS

Line 1466: FUNCTION isLocationEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS

1462: FUNCTION checkRuleOption(p_policy_id IN ap_pol_headers.policy_id%TYPE,
1463: p_rule IN VARCHAR2) RETURN VARCHAR2 IS
1464:
1465:
1466: FUNCTION isLocationEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1467:
1468: l_location_flag ap_pol_headers.location_flag%TYPE;
1469: l_location_count number := 0;
1470:

Line 1468: l_location_flag ap_pol_headers.location_flag%TYPE;

1464:
1465:
1466: FUNCTION isLocationEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1467:
1468: l_location_flag ap_pol_headers.location_flag%TYPE;
1469: l_location_count number := 0;
1470:
1471: BEGIN
1472: select location_flag

Line 1474: from ap_pol_headers

1470:
1471: BEGIN
1472: select location_flag
1473: into l_location_flag
1474: from ap_pol_headers
1475: where policy_id = p_policy_id;
1476:
1477: select count(location_id)
1478: into l_location_count

Line 1498: FUNCTION isRoleEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS

1494: WHEN OTHERS THEN
1495: raise;
1496: END isLocationEnabled;
1497:
1498: FUNCTION isRoleEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1499:
1500: l_employee_role_flag ap_pol_headers.employee_role_flag%TYPE;
1501: l_role_count number := 0;
1502:

Line 1500: l_employee_role_flag ap_pol_headers.employee_role_flag%TYPE;

1496: END isLocationEnabled;
1497:
1498: FUNCTION isRoleEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1499:
1500: l_employee_role_flag ap_pol_headers.employee_role_flag%TYPE;
1501: l_role_count number := 0;
1502:
1503: BEGIN
1504: select employee_role_flag

Line 1506: from ap_pol_headers

1502:
1503: BEGIN
1504: select employee_role_flag
1505: into l_employee_role_flag
1506: from ap_pol_headers
1507: where policy_id = p_policy_id;
1508:
1509: select count(role_id)
1510: into l_role_count

Line 1530: FUNCTION isCurrencyEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS

1526: WHEN OTHERS THEN
1527: raise;
1528: END isRoleEnabled;
1529:
1530: FUNCTION isCurrencyEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1531:
1532: l_currency_preference ap_pol_headers.currency_preference%TYPE;
1533: l_currency_count number := 0;
1534:

Line 1532: l_currency_preference ap_pol_headers.currency_preference%TYPE;

1528: END isRoleEnabled;
1529:
1530: FUNCTION isCurrencyEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1531:
1532: l_currency_preference ap_pol_headers.currency_preference%TYPE;
1533: l_currency_count number := 0;
1534:
1535: BEGIN
1536: select currency_preference

Line 1538: from ap_pol_headers

1534:
1535: BEGIN
1536: select currency_preference
1537: into l_currency_preference
1538: from ap_pol_headers
1539: where policy_id = p_policy_id;
1540:
1541: select count(currency_code)
1542: into l_currency_count

Line 1562: FUNCTION isVehicleCategoryEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS

1558: WHEN OTHERS THEN
1559: raise;
1560: END isCurrencyEnabled;
1561:
1562: FUNCTION isVehicleCategoryEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1563:
1564: l_vehicle_category_flag ap_pol_headers.vehicle_category_flag%TYPE;
1565: l_vehicle_category_count number := 0;
1566:

Line 1564: l_vehicle_category_flag ap_pol_headers.vehicle_category_flag%TYPE;

1560: END isCurrencyEnabled;
1561:
1562: FUNCTION isVehicleCategoryEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1563:
1564: l_vehicle_category_flag ap_pol_headers.vehicle_category_flag%TYPE;
1565: l_vehicle_category_count number := 0;
1566:
1567: BEGIN
1568: select vehicle_category_flag

Line 1570: from ap_pol_headers

1566:
1567: BEGIN
1568: select vehicle_category_flag
1569: into l_vehicle_category_flag
1570: from ap_pol_headers
1571: where policy_id = p_policy_id;
1572:
1573: select count(option_code)
1574: into l_vehicle_category_count

Line 1594: FUNCTION isVehicleTypeEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS

1590: WHEN OTHERS THEN
1591: raise;
1592: END isVehicleCategoryEnabled;
1593:
1594: FUNCTION isVehicleTypeEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1595:
1596: l_vehicle_type_flag ap_pol_headers.vehicle_type_flag%TYPE;
1597: l_vehicle_type_count number := 0;
1598:

Line 1596: l_vehicle_type_flag ap_pol_headers.vehicle_type_flag%TYPE;

1592: END isVehicleCategoryEnabled;
1593:
1594: FUNCTION isVehicleTypeEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1595:
1596: l_vehicle_type_flag ap_pol_headers.vehicle_type_flag%TYPE;
1597: l_vehicle_type_count number := 0;
1598:
1599: BEGIN
1600: select vehicle_type_flag

Line 1602: from ap_pol_headers

1598:
1599: BEGIN
1600: select vehicle_type_flag
1601: into l_vehicle_type_flag
1602: from ap_pol_headers
1603: where policy_id = p_policy_id;
1604:
1605: select count(option_code)
1606: into l_vehicle_type_count

Line 1626: FUNCTION isFuelTypeEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS

1622: WHEN OTHERS THEN
1623: raise;
1624: END isVehicleTypeEnabled;
1625:
1626: FUNCTION isFuelTypeEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1627:
1628: l_fuel_type_flag ap_pol_headers.fuel_type_flag%TYPE;
1629: l_fuel_type_count number := 0;
1630:

Line 1628: l_fuel_type_flag ap_pol_headers.fuel_type_flag%TYPE;

1624: END isVehicleTypeEnabled;
1625:
1626: FUNCTION isFuelTypeEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1627:
1628: l_fuel_type_flag ap_pol_headers.fuel_type_flag%TYPE;
1629: l_fuel_type_count number := 0;
1630:
1631: BEGIN
1632: select fuel_type_flag

Line 1634: from ap_pol_headers

1630:
1631: BEGIN
1632: select fuel_type_flag
1633: into l_fuel_type_flag
1634: from ap_pol_headers
1635: where policy_id = p_policy_id;
1636:
1637: select count(option_code)
1638: into l_fuel_type_count

Line 1658: FUNCTION isTimeThresholdsEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS

1654: WHEN OTHERS THEN
1655: raise;
1656: END isFuelTypeEnabled;
1657:
1658: FUNCTION isTimeThresholdsEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1659:
1660: l_time_based_entry_flag ap_pol_headers.time_based_entry_flag%TYPE;
1661: l_thresholds_count number := 0;
1662:

Line 1660: l_time_based_entry_flag ap_pol_headers.time_based_entry_flag%TYPE;

1656: END isFuelTypeEnabled;
1657:
1658: FUNCTION isTimeThresholdsEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1659:
1660: l_time_based_entry_flag ap_pol_headers.time_based_entry_flag%TYPE;
1661: l_thresholds_count number := 0;
1662:
1663: BEGIN
1664: select nvl(time_based_entry_flag, 'N')

Line 1666: from ap_pol_headers

1662:
1663: BEGIN
1664: select nvl(time_based_entry_flag, 'N')
1665: into l_time_based_entry_flag
1666: from ap_pol_headers
1667: where policy_id = p_policy_id;
1668:
1669: select count(threshold)
1670: into l_thresholds_count

Line 1690: FUNCTION isDistanceThresholdsEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS

1686: WHEN OTHERS THEN
1687: raise;
1688: END isTimeThresholdsEnabled;
1689:
1690: FUNCTION isDistanceThresholdsEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1691:
1692: l_distance_thresholds_flag ap_pol_headers.distance_thresholds_flag%TYPE;
1693: l_thresholds_count number := 0;
1694:

Line 1692: l_distance_thresholds_flag ap_pol_headers.distance_thresholds_flag%TYPE;

1688: END isTimeThresholdsEnabled;
1689:
1690: FUNCTION isDistanceThresholdsEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1691:
1692: l_distance_thresholds_flag ap_pol_headers.distance_thresholds_flag%TYPE;
1693: l_thresholds_count number := 0;
1694:
1695: BEGIN
1696: select nvl2(distance_thresholds_flag, 'Y', 'N')

Line 1698: from ap_pol_headers

1694:
1695: BEGIN
1696: select nvl2(distance_thresholds_flag, 'Y', 'N')
1697: into l_distance_thresholds_flag
1698: from ap_pol_headers
1699: where policy_id = p_policy_id;
1700:
1701: select count(threshold)
1702: into l_thresholds_count

Line 1722: FUNCTION isThresholdsEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS

1718: WHEN OTHERS THEN
1719: raise;
1720: END isDistanceThresholdsEnabled;
1721:
1722: FUNCTION isThresholdsEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1723:
1724: l_distance_thresholds_flag ap_pol_headers.distance_thresholds_flag%TYPE;
1725: l_time_thresholds_flag ap_pol_headers.time_based_entry_flag%TYPE;
1726:

Line 1724: l_distance_thresholds_flag ap_pol_headers.distance_thresholds_flag%TYPE;

1720: END isDistanceThresholdsEnabled;
1721:
1722: FUNCTION isThresholdsEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1723:
1724: l_distance_thresholds_flag ap_pol_headers.distance_thresholds_flag%TYPE;
1725: l_time_thresholds_flag ap_pol_headers.time_based_entry_flag%TYPE;
1726:
1727: BEGIN
1728:

Line 1725: l_time_thresholds_flag ap_pol_headers.time_based_entry_flag%TYPE;

1721:
1722: FUNCTION isThresholdsEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1723:
1724: l_distance_thresholds_flag ap_pol_headers.distance_thresholds_flag%TYPE;
1725: l_time_thresholds_flag ap_pol_headers.time_based_entry_flag%TYPE;
1726:
1727: BEGIN
1728:
1729: l_distance_thresholds_flag := isDistanceThresholdsEnabled(p_policy_id);

Line 1747: FUNCTION isAddonRatesEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS

1743: WHEN OTHERS THEN
1744: raise;
1745: END isThresholdsEnabled;
1746:
1747: FUNCTION isAddonRatesEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1748: l_addon_mileage_rates_flag ap_pol_headers.addon_mileage_rates_flag%TYPE;
1749: l_addon_rates_count number := 0;
1750: BEGIN
1751:

Line 1748: l_addon_mileage_rates_flag ap_pol_headers.addon_mileage_rates_flag%TYPE;

1744: raise;
1745: END isThresholdsEnabled;
1746:
1747: FUNCTION isAddonRatesEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
1748: l_addon_mileage_rates_flag ap_pol_headers.addon_mileage_rates_flag%TYPE;
1749: l_addon_rates_count number := 0;
1750: BEGIN
1751:
1752: select nvl(addon_mileage_rates_flag, 'N')

Line 1754: from ap_pol_headers

1750: BEGIN
1751:
1752: select nvl(addon_mileage_rates_flag, 'N')
1753: into l_addon_mileage_rates_flag
1754: from ap_pol_headers
1755: where policy_id = p_policy_id;
1756:
1757: select count(1)
1758: into l_addon_rates_count

Line 1818: FUNCTION getUnionStmtForRuleOption(p_policy_id IN ap_pol_headers.policy_id%TYPE,

1814: | Date Author Description of Changes
1815: | 16-May-2002 R Langi Created
1816: |
1817: *=======================================================================*/
1818: FUNCTION getUnionStmtForRuleOption(p_policy_id IN ap_pol_headers.policy_id%TYPE,
1819: p_rule IN VARCHAR2) RETURN VARCHAR2 IS
1820:
1821: l_currency_preference ap_pol_headers.currency_preference%TYPE;
1822:

Line 1821: l_currency_preference ap_pol_headers.currency_preference%TYPE;

1817: *=======================================================================*/
1818: FUNCTION getUnionStmtForRuleOption(p_policy_id IN ap_pol_headers.policy_id%TYPE,
1819: p_rule IN VARCHAR2) RETURN VARCHAR2 IS
1820:
1821: l_currency_preference ap_pol_headers.currency_preference%TYPE;
1822:
1823: l_src_stmt VARCHAR2(160) := 'union all select CURRENCY_CODE from ap_pol_headers where POLICY_ID = :p_policy_id';
1824:
1825: l_vc_stmt VARCHAR2(80) := 'union all select to_char(null), to_char(null), to_char(null) from sys.dual';

Line 1823: l_src_stmt VARCHAR2(160) := 'union all select CURRENCY_CODE from ap_pol_headers where POLICY_ID = :p_policy_id';

1819: p_rule IN VARCHAR2) RETURN VARCHAR2 IS
1820:
1821: l_currency_preference ap_pol_headers.currency_preference%TYPE;
1822:
1823: l_src_stmt VARCHAR2(160) := 'union all select CURRENCY_CODE from ap_pol_headers where POLICY_ID = :p_policy_id';
1824:
1825: l_vc_stmt VARCHAR2(80) := 'union all select to_char(null), to_char(null), to_char(null) from sys.dual';
1826: l_number_stmt VARCHAR2(80) := 'union all select to_number(null) from sys.dual';
1827: l_number2_stmt VARCHAR2(80) := 'union all select to_number(null), to_number(null) from sys.dual';

Line 1834: from ap_pol_headers

1830: BEGIN
1831:
1832: select currency_preference
1833: into l_currency_preference
1834: from ap_pol_headers
1835: where policy_id = p_policy_id;
1836:
1837: if (checkRuleOption(p_policy_id, p_rule) = 'Y')
1838: then

Line 1845: we must still permutate using ap_pol_headers.currency_code

1841: if (p_rule = c_CURRENCY) then
1842: if (l_currency_preference = c_SRC) then
1843: /*
1844: if Single Rate Currency there will be no records in ap_pol_schedule_options
1845: we must still permutate using ap_pol_headers.currency_code
1846: */
1847: return l_src_stmt;
1848: else
1849: /*

Line 1899: PROCEDURE checkAirfarePolicyLines(p_policy_id IN ap_pol_headers.policy_id%TYPE) IS

1895: | Date Author Description of Changes
1896: | 24-Dec-2002 R Langi Created
1897: |
1898: *=======================================================================*/
1899: PROCEDURE checkAirfarePolicyLines(p_policy_id IN ap_pol_headers.policy_id%TYPE) IS
1900:
1901: BEGIN
1902:
1903: if (getPolicyCategoryCode(p_policy_id) <> 'AIRFARE')

Line 1950: p_policy_id IN ap_pol_headers.policy_id%TYPE) IS

1946: | 16-May-2002 R Langi Created
1947: |
1948: *=======================================================================*/
1949: PROCEDURE permutatePolicyLines(p_user_id IN NUMBER,
1950: p_policy_id IN ap_pol_headers.policy_id%TYPE) IS
1951:
1952: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
1953: l_permutate_curref INTEGER;
1954: l_rows_permutated NUMBER := 0;

Line 1982: l_category_code ap_pol_headers.category_code%TYPE;

1978: l_night_rates_enabled VARCHAR2(1) := isNightRatesEnabled(p_policy_id);
1979:
1980: l_schedule_option_rec ap_pol_schedule_options%ROWTYPE;
1981: l_zero_threshold_count NUMBER;
1982: l_category_code ap_pol_headers.category_code%TYPE;
1983: l_rate_type_code ap_pol_schedule_options.rate_type_code%TYPE;
1984: l_schedule_type ap_pol_headers.schedule_type_code%TYPE;
1985: l_source ap_pol_headers.source%TYPE;
1986:

Line 1984: l_schedule_type ap_pol_headers.schedule_type_code%TYPE;

1980: l_schedule_option_rec ap_pol_schedule_options%ROWTYPE;
1981: l_zero_threshold_count NUMBER;
1982: l_category_code ap_pol_headers.category_code%TYPE;
1983: l_rate_type_code ap_pol_schedule_options.rate_type_code%TYPE;
1984: l_schedule_type ap_pol_headers.schedule_type_code%TYPE;
1985: l_source ap_pol_headers.source%TYPE;
1986:
1987: ---------------------------------------
1988: -- cursor for schedule periods

Line 1985: l_source ap_pol_headers.source%TYPE;

1981: l_zero_threshold_count NUMBER;
1982: l_category_code ap_pol_headers.category_code%TYPE;
1983: l_rate_type_code ap_pol_schedule_options.rate_type_code%TYPE;
1984: l_schedule_type ap_pol_headers.schedule_type_code%TYPE;
1985: l_source ap_pol_headers.source%TYPE;
1986:
1987: ---------------------------------------
1988: -- cursor for schedule periods
1989: ---------------------------------------

Line 2269: from ap_pol_headers

2265: BEGIN
2266:
2267: select category_code, schedule_type_code, source
2268: into l_category_code, l_schedule_type, l_source
2269: from ap_pol_headers
2270: where policy_id = p_policy_id;
2271:
2272: -- ---------------------------------------------------------------
2273: -- If this is a CONUS/OCONUS policy then call the appropriate

Line 2365: from ap_pol_headers

2361: -- for midnight to midnight schedules which have first and last rates
2362: -- or for allowance schedules with time rule of start and end times
2363: select count(1)
2364: into l_zero_threshold_count
2365: from ap_pol_headers
2366: where policy_id = p_policy_id
2367: and time_based_entry_flag = 'Y'
2368: and ( day_period_code <> 'MIDNIGHT' or
2369: (nvl(rate_period_type_code, 'STANDARD') = 'STANDARD' and schedule_type_code = 'PER_DIEM') or

Line 2653: PROCEDURE removeObsoletedPolicyLines(p_policy_id IN ap_pol_headers.policy_id%TYPE) IS

2649: | Date Author Description of Changes
2650: | 16-May-2002 R Langi Created
2651: |
2652: *=======================================================================*/
2653: PROCEDURE removeObsoletedPolicyLines(p_policy_id IN ap_pol_headers.policy_id%TYPE) IS
2654:
2655: l_obsolete_curref INTEGER;
2656: l_rows_obsoleted NUMBER := 0;
2657:

Line 2668: l_currency_preference ap_pol_headers.currency_preference%TYPE;

2664: l_ft_sql_stmt VARCHAR2(4000);
2665: l_dt_sql_stmt VARCHAR2(4000);
2666: l_amr_sql_stmt VARCHAR2(4000);
2667:
2668: l_currency_preference ap_pol_headers.currency_preference%TYPE;
2669: l_currency_code ap_pol_headers.currency_code%TYPE;
2670:
2671: cursor l_l_cursor is
2672: select

Line 2669: l_currency_code ap_pol_headers.currency_code%TYPE;

2665: l_dt_sql_stmt VARCHAR2(4000);
2666: l_amr_sql_stmt VARCHAR2(4000);
2667:
2668: l_currency_preference ap_pol_headers.currency_preference%TYPE;
2669: l_currency_code ap_pol_headers.currency_code%TYPE;
2670:
2671: cursor l_l_cursor is
2672: select
2673: '

Line 2744: from AP_POL_HEADERS ph

2740: )
2741: and
2742: not exists
2743: (select ph.CURRENCY_PREFERENCE
2744: from AP_POL_HEADERS ph
2745: where ph.POLICY_ID = pl.POLICY_ID
2746: and (ph.CURRENCY_PREFERENCE = :c_SRC
2747: or
2748: ph.CURRENCY_PREFERENCE = :c_LCR

Line 2758: from AP_POL_HEADERS ph

2754: (pl.CURRENCY_CODE is not null
2755: and
2756: exists
2757: (select ph.CURRENCY_PREFERENCE
2758: from AP_POL_HEADERS ph
2759: where ph.POLICY_ID = pl.POLICY_ID
2760: and ph.CURRENCY_PREFERENCE = :c_SRC
2761: )
2762: and

Line 2765: from AP_POL_HEADERS ph

2761: )
2762: and
2763: not exists
2764: (select ph.CURRENCY_CODE
2765: from AP_POL_HEADERS ph
2766: where ph.POLICY_ID = pl.POLICY_ID
2767: and ph.CURRENCY_CODE = pl.CURRENCY_CODE
2768: )
2769: )

Line 3064: PROCEDURE updateInactivePolicyLines(p_policy_id IN ap_pol_headers.policy_id%TYPE) IS

3060: | Date Author Description of Changes
3061: | 16-May-2002 R Langi Created
3062: |
3063: *=======================================================================*/
3064: PROCEDURE updateInactivePolicyLines(p_policy_id IN ap_pol_headers.policy_id%TYPE) IS
3065:
3066: l_inactive_curref INTEGER;
3067: l_rows_inactivated NUMBER := 0;
3068:

Line 3217: from AP_POL_HEADERS ph

3213: and nvl(pso.END_DATE, SYSDATE+1) > SYSDATE
3214: )
3215: or exists
3216: (select ph.CURRENCY_CODE
3217: from AP_POL_HEADERS ph
3218: where ph.POLICY_ID = pl.POLICY_ID
3219: and ((ph.CURRENCY_CODE is not null and ph.CURRENCY_CODE = pl.CURRENCY_CODE)
3220: or
3221: (ph.CURRENCY_CODE is null and ph.CURRENCY_PREFERENCE <> :c_SRC)))

Line 3405: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,

3401: | 16-May-2002 R Langi Created
3402: |
3403: *=======================================================================*/
3404: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
3405: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
3406: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
3407: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
3408: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE) IS
3409:

Line 3407: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,

3403: *=======================================================================*/
3404: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
3405: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
3406: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
3407: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
3408: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE) IS
3409:
3410: l_duplicate_curref INTEGER;
3411: l_rows_duplicated NUMBER := 0;

Line 4018: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,

4014: | date when a schedule is duplicated.
4015: |
4016: *=======================================================================*/
4017: PROCEDURE duplicatePolicy(p_user_id IN NUMBER,
4018: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
4019: p_new_policy_id OUT NOCOPY ap_pol_headers.policy_id%TYPE) IS
4020:
4021: l_duplicate_header_sql_stmt VARCHAR2(4000);
4022: l_duplicate_options_sql_stmt VARCHAR2(4000);

Line 4019: p_new_policy_id OUT NOCOPY ap_pol_headers.policy_id%TYPE) IS

4015: |
4016: *=======================================================================*/
4017: PROCEDURE duplicatePolicy(p_user_id IN NUMBER,
4018: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
4019: p_new_policy_id OUT NOCOPY ap_pol_headers.policy_id%TYPE) IS
4020:
4021: l_duplicate_header_sql_stmt VARCHAR2(4000);
4022: l_duplicate_options_sql_stmt VARCHAR2(4000);
4023:

Line 4024: l_from_policy_id ap_pol_headers.policy_id%TYPE;

4020:
4021: l_duplicate_header_sql_stmt VARCHAR2(4000);
4022: l_duplicate_options_sql_stmt VARCHAR2(4000);
4023:
4024: l_from_policy_id ap_pol_headers.policy_id%TYPE;
4025: l_to_policy_id ap_pol_headers.policy_id%TYPE;
4026:
4027: l_from_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
4028: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;

Line 4025: l_to_policy_id ap_pol_headers.policy_id%TYPE;

4021: l_duplicate_header_sql_stmt VARCHAR2(4000);
4022: l_duplicate_options_sql_stmt VARCHAR2(4000);
4023:
4024: l_from_policy_id ap_pol_headers.policy_id%TYPE;
4025: l_to_policy_id ap_pol_headers.policy_id%TYPE;
4026:
4027: l_from_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
4028: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
4029:

Line 4067: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,

4063:
4064:
4065:
4066: PROCEDURE duplicatePolicyHeader(p_user_id IN NUMBER,
4067: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
4068: p_to_policy_id OUT NOCOPY ap_pol_headers.policy_id%TYPE) IS
4069:
4070: BEGIN
4071:

Line 4068: p_to_policy_id OUT NOCOPY ap_pol_headers.policy_id%TYPE) IS

4064:
4065:
4066: PROCEDURE duplicatePolicyHeader(p_user_id IN NUMBER,
4067: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
4068: p_to_policy_id OUT NOCOPY ap_pol_headers.policy_id%TYPE) IS
4069:
4070: BEGIN
4071:
4072: select AP_POL_HEADERS_S.NEXTVAL

Line 4072: select AP_POL_HEADERS_S.NEXTVAL

4068: p_to_policy_id OUT NOCOPY ap_pol_headers.policy_id%TYPE) IS
4069:
4070: BEGIN
4071:
4072: select AP_POL_HEADERS_S.NEXTVAL
4073: into p_to_policy_id
4074: from sys.dual;
4075:
4076:

Line 4077: insert into AP_POL_HEADERS

4073: into p_to_policy_id
4074: from sys.dual;
4075:
4076:
4077: insert into AP_POL_HEADERS
4078: (
4079: POLICY_ID,
4080: CATEGORY_CODE,
4081: POLICY_NAME,

Line 4202: AP_POL_HEADERS

4198: p_user_id AS LAST_UPDATED_BY,
4199: REIMBURSEMENT_PERCENTAGE_FLAG,
4200: REIMBURSEMENT_PERCENTAGE_CODE
4201: from
4202: AP_POL_HEADERS
4203: where POLICY_ID = p_from_policy_id;
4204:
4205: EXCEPTION
4206: WHEN OTHERS THEN

Line 4212: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,

4208: END duplicatePolicyHeader;
4209:
4210:
4211: PROCEDURE duplicatePolicyScheduleOptions(p_user_id IN NUMBER,
4212: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
4213: p_to_policy_id IN ap_pol_headers.policy_id%TYPE) IS
4214:
4215: BEGIN
4216:

Line 4213: p_to_policy_id IN ap_pol_headers.policy_id%TYPE) IS

4209:
4210:
4211: PROCEDURE duplicatePolicyScheduleOptions(p_user_id IN NUMBER,
4212: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
4213: p_to_policy_id IN ap_pol_headers.policy_id%TYPE) IS
4214:
4215: BEGIN
4216:
4217: insert into AP_POL_SCHEDULE_OPTIONS

Line 4603: FUNCTION are_exp_type_enddates_capped(p_policy_id IN ap_pol_headers.policy_id%TYPE,

4599: | Date Author Description of Changes
4600: | 31-JUL-2002 Mohammad Shoaib Jamall Created
4601: |
4602: *=======================================================================*/
4603: FUNCTION are_exp_type_enddates_capped(p_policy_id IN ap_pol_headers.policy_id%TYPE,
4604: p_end_date IN ap_pol_headers.end_date%TYPE) RETURN VARCHAR2 IS
4605: l_count_rows NUMBER := 0;
4606: l_return_val VARCHAR2(1);
4607: BEGIN

Line 4604: p_end_date IN ap_pol_headers.end_date%TYPE) RETURN VARCHAR2 IS

4600: | 31-JUL-2002 Mohammad Shoaib Jamall Created
4601: |
4602: *=======================================================================*/
4603: FUNCTION are_exp_type_enddates_capped(p_policy_id IN ap_pol_headers.policy_id%TYPE,
4604: p_end_date IN ap_pol_headers.end_date%TYPE) RETURN VARCHAR2 IS
4605: l_count_rows NUMBER := 0;
4606: l_return_val VARCHAR2(1);
4607: BEGIN
4608:

Line 4657: PROCEDURE cap_expense_type_enddates(p_policy_id IN ap_pol_headers.policy_id%TYPE,

4653: | Date Author Description of Changes
4654: | 31-JUL-2002 Mohammad Shoaib Jamall Created
4655: |
4656: *=======================================================================*/
4657: PROCEDURE cap_expense_type_enddates(p_policy_id IN ap_pol_headers.policy_id%TYPE,
4658: p_end_date IN ap_pol_headers.end_date%TYPE) IS
4659: PRAGMA AUTONOMOUS_TRANSACTION;
4660:
4661: l_are_enddates_capped VARCHAR2(1);

Line 4658: p_end_date IN ap_pol_headers.end_date%TYPE) IS

4654: | 31-JUL-2002 Mohammad Shoaib Jamall Created
4655: |
4656: *=======================================================================*/
4657: PROCEDURE cap_expense_type_enddates(p_policy_id IN ap_pol_headers.policy_id%TYPE,
4658: p_end_date IN ap_pol_headers.end_date%TYPE) IS
4659: PRAGMA AUTONOMOUS_TRANSACTION;
4660:
4661: l_are_enddates_capped VARCHAR2(1);
4662: BEGIN

Line 5002: p_policy_id IN ap_pol_headers.policy_id%TYPE,

4998: | 16-May-2002 R Langi Created
4999: |
5000: *=======================================================================*/
5001: PROCEDURE permutatePolicyLines(p_user_id IN NUMBER,
5002: p_policy_id IN ap_pol_headers.policy_id%TYPE,
5003: p_rate_type IN ap_pol_schedule_options.rate_type_code%TYPE) IS
5004:
5005: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
5006: l_permutate_curref INTEGER;

Line 5360: p_policy_id IN ap_pol_headers.policy_id%TYPE,

5356: | 10-Nov-2005 krmenon Created
5357: |
5358: *=======================================================================*/
5359: PROCEDURE permutateAddonRates( p_user_id IN NUMBER,
5360: p_policy_id IN ap_pol_headers.policy_id%TYPE,
5361: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE ) IS
5362:
5363: l_policy_line_count NUMBER;
5364:

Line 5544: p_policy_id IN ap_pol_headers.policy_id%TYPE,

5540: | 10-Nov-2005 krmenon Created
5541: |
5542: *=======================================================================*/
5543: PROCEDURE permutateNightRates( p_user_id IN NUMBER,
5544: p_policy_id IN ap_pol_headers.policy_id%TYPE,
5545: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE ) IS
5546:
5547: -- -------------------------------------
5548: -- Cursor for inserting new permutation

Line 5612: l_night_rates_code ap_pol_headers.night_rates_code%TYPE;

5608: -- ------------------------------------
5609: -- Local variables
5610: -- ------------------------------------
5611: l_policy_line_count NUMBER;
5612: l_night_rates_code ap_pol_headers.night_rates_code%TYPE;
5613:
5614: BEGIN
5615:
5616: BEGIN

Line 5677: from ap_pol_headers

5673: -- ----------------------------------------------------------------
5674: BEGIN
5675: select night_rates_code
5676: into l_night_rates_code
5677: from ap_pol_headers
5678: where policy_id = p_policy_id;
5679: EXCEPTION WHEN OTHERS THEN
5680: raise;
5681: END;

Line 5773: FUNCTION isNightRatesEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS

5769: | Date Author Description of Changes
5770: | 10-Nov-2005 krmenon Created
5771: |
5772: *=======================================================================*/
5773: FUNCTION isNightRatesEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2 IS
5774: l_night_rate_flag VARCHAR2(1) := 'N';
5775: BEGIN
5776:
5777: select nvl2(night_rates_code, 'Y', 'N' )

Line 5779: from ap_pol_headers

5775: BEGIN
5776:
5777: select nvl2(night_rates_code, 'Y', 'N' )
5778: into l_night_rate_flag
5779: from ap_pol_headers
5780: where policy_id = p_policy_id;
5781:
5782: return l_night_rate_flag;
5783:

Line 5813: FUNCTION isFirstPeriodRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2 IS

5809: | Date Author Description of Changes
5810: | 10-Nov-2005 krmenon Created
5811: |
5812: *=======================================================================*/
5813: FUNCTION isFirstPeriodRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2 IS
5814: l_rate_period_type_code ap_pol_headers.night_rates_code%TYPE;
5815: l_first_period_count number := 0;
5816: BEGIN
5817:

Line 5814: l_rate_period_type_code ap_pol_headers.night_rates_code%TYPE;

5810: | 10-Nov-2005 krmenon Created
5811: |
5812: *=======================================================================*/
5813: FUNCTION isFirstPeriodRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2 IS
5814: l_rate_period_type_code ap_pol_headers.night_rates_code%TYPE;
5815: l_first_period_count number := 0;
5816: BEGIN
5817:
5818: select nvl(rate_period_type_code, 'STANDARD')

Line 5820: from ap_pol_headers

5816: BEGIN
5817:
5818: select nvl(rate_period_type_code, 'STANDARD')
5819: into l_rate_period_type_code
5820: from ap_pol_headers
5821: where policy_id = p_policy_id;
5822:
5823: select count(1)
5824: into l_first_period_count

Line 5864: FUNCTION isLastPeriodRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2 IS

5860: | Date Author Description of Changes
5861: | 10-Nov-2005 krmenon Created
5862: |
5863: *=======================================================================*/
5864: FUNCTION isLastPeriodRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2 IS
5865: l_rate_period_type_code ap_pol_headers.night_rates_code%TYPE;
5866: l_last_period_count number := 0;
5867: BEGIN
5868:

Line 5865: l_rate_period_type_code ap_pol_headers.night_rates_code%TYPE;

5861: | 10-Nov-2005 krmenon Created
5862: |
5863: *=======================================================================*/
5864: FUNCTION isLastPeriodRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2 IS
5865: l_rate_period_type_code ap_pol_headers.night_rates_code%TYPE;
5866: l_last_period_count number := 0;
5867: BEGIN
5868:
5869: select nvl(rate_period_type_code, 'STANDARD')

Line 5871: from ap_pol_headers

5867: BEGIN
5868:
5869: select nvl(rate_period_type_code, 'STANDARD')
5870: into l_rate_period_type_code
5871: from ap_pol_headers
5872: where policy_id = p_policy_id;
5873:
5874: select count(1)
5875: into l_last_period_count

Line 5914: FUNCTION isSameDayRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2 IS

5910: | Date Author Description of Changes
5911: | 10-Nov-2005 krmenon Created
5912: |
5913: *=======================================================================*/
5914: FUNCTION isSameDayRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2 IS
5915: l_same_day_rate_code ap_pol_headers.night_rates_code%TYPE;
5916: l_same_day_count number := 0;
5917: BEGIN
5918:

Line 5915: l_same_day_rate_code ap_pol_headers.night_rates_code%TYPE;

5911: | 10-Nov-2005 krmenon Created
5912: |
5913: *=======================================================================*/
5914: FUNCTION isSameDayRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2 IS
5915: l_same_day_rate_code ap_pol_headers.night_rates_code%TYPE;
5916: l_same_day_count number := 0;
5917: BEGIN
5918:
5919: select nvl(same_day_rate_code, 'NULL')

Line 5921: from ap_pol_headers

5917: BEGIN
5918:
5919: select nvl(same_day_rate_code, 'NULL')
5920: into l_same_day_rate_code
5921: from ap_pol_headers
5922: where policy_id = p_policy_id;
5923:
5924: select count(1)
5925: into l_same_day_count

Line 5967: p_policy_id IN ap_pol_headers.policy_id%TYPE) IS

5963: | Date Author Description of Changes
5964: | 07-Dec-2005 krmenon Created |
5965: *=======================================================================*/
5966: PROCEDURE permutateConusLines( p_user_id IN NUMBER,
5967: p_policy_id IN ap_pol_headers.policy_id%TYPE) IS
5968:
5969: l_role_enabled VARCHAR2(1);
5970: BEGIN
5971:

Line 6293: from AP_POL_HEADERS h, ap_expense_report_params_all p

6289:
6290: l_hr_assignment := Gethrassignment(p_person_id, p_expense_date);
6291:
6292: select nvl(h.location_flag, 'N') into l_location_enabled
6293: from AP_POL_HEADERS h, ap_expense_report_params_all p
6294: where p.parameter_Id = p_expense_type_id
6295: and h.policy_Id = p.company_policy_id;
6296:
6297: If(l_location_enabled = 'Y' And p_location_id Is Null) Then

Line 6305: from AP_POL_HEADERS h, AP_POL_LINES l, AP_POL_SCHEDULE_PERIODS sp, AP_SYSTEM_PARAMETERS sys, AP_POL_EXRATE_OPTIONS rate_opts, ap_expense_report_params_all p

6301: End If;
6302:
6303: select l.POLICY_LINE_ID
6304: INTO l_policy_line_id
6305: from AP_POL_HEADERS h, AP_POL_LINES l, AP_POL_SCHEDULE_PERIODS sp, AP_SYSTEM_PARAMETERS sys, AP_POL_EXRATE_OPTIONS rate_opts, ap_expense_report_params_all p
6306: where p.parameter_id = p_expense_type_id
6307: AND h.policy_id = p.company_policy_id
6308: AND h.category_code <> 'MILEAGE'
6309: AND h.category_code <> 'PER_DIEM'

Line 7738: from ap_pol_headers ph,

7734: ph.policy_id,
7735: Pl.Policy_Line_Id,
7736: ph.role_code,
7737: pl.role_id
7738: from ap_pol_headers ph,
7739: ap_pol_lines pl
7740: where pl.policy_id = ph.policy_id
7741: and ph.policy_id = p_policy_id;
7742: