APPS.AP_WEB_DB_SCHLINE_PKG dependencies on AP_POL_LINES

Line 32: AP_POL_LINES SL

28: SL.rate,
29: decode(SH.passengers_flag,null,0,decode(calculation_method, 'AMOUNT', NVL(SL.rate_per_passenger,0), 'PERCENT', NVL(SL.rate_per_passenger,0)/100* SL.rate, 0)) rate_per_passenger
30: FROM AP_POL_HEADERS SH,
31: AP_POL_SCHEDULE_PERIODS SP,
32: AP_POL_LINES SL
33: WHERE SH.POLICY_ID = p_policy_id
34: AND SH.POLICY_ID = SL.POLICY_ID
35: AND nvl(SL.ROLE_ID,0) = getRoleId(p_policy_id,p_employee_id,p_start_expense_date)
36: AND nvl(SL.VEHICLE_CATEGORY,0) = decode(

Line 127: SELECT ROLE_ID INTO l_role_code FROM AP_POL_LINES WHERE POLICY_ID = p_policy_id and ROLE_ID = l_role_code and rownum = 1;

123: AND ROWNUM = 1;
124:
125: IF(l_role_code > 0) THEN
126: BEGIN
127: SELECT ROLE_ID INTO l_role_code FROM AP_POL_LINES WHERE POLICY_ID = p_policy_id and ROLE_ID = l_role_code and rownum = 1;
128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN
130: RETURN -1;
131: END;