APPS.AP_WEB_DB_SCHLINE_PKG dependencies on AP_POL_SCHEDULE_PERIODS

Line 31: AP_POL_SCHEDULE_PERIODS SP,

27: SL.rate,
28: 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
29: FROM AP_POL_LINES SL,
30: AP_POL_HEADERS SH,
31: AP_POL_SCHEDULE_PERIODS SP,
32: PER_ALL_ASSIGNMENTS_F PF
33: WHERE SH.POLICY_ID = p_policy_id
34: AND SH.POLICY_ID = SL.POLICY_ID
35: AND (nvl(SL.ROLE_ID,0) = decode(