APPS.AP_WEB_DB_SCHLINE_PKG dependencies on AP_POL_HEADERS

Line 30: AP_POL_HEADERS SH,

26: SP.END_DATE,
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

Line 81: p_policy_id IN ap_pol_headers.policy_id%TYPE,

77:
78:
79: --------------------------------------------------------------------------------
80: PROCEDURE getSchHeaderInfo(
81: p_policy_id IN ap_pol_headers.policy_id%TYPE,
82: p_sh_distance_uom OUT NOCOPY ap_pol_headers.distance_uom%TYPE,
83: p_sh_currency_code OUT NOCOPY ap_pol_headers.currency_code%TYPE,
84: p_sh_distance_thresholds_flag OUT NOCOPY ap_pol_headers.distance_thresholds_flag%TYPE) IS
85: --------------------------------------------------------------------------------

Line 82: p_sh_distance_uom OUT NOCOPY ap_pol_headers.distance_uom%TYPE,

78:
79: --------------------------------------------------------------------------------
80: PROCEDURE getSchHeaderInfo(
81: p_policy_id IN ap_pol_headers.policy_id%TYPE,
82: p_sh_distance_uom OUT NOCOPY ap_pol_headers.distance_uom%TYPE,
83: p_sh_currency_code OUT NOCOPY ap_pol_headers.currency_code%TYPE,
84: p_sh_distance_thresholds_flag OUT NOCOPY ap_pol_headers.distance_thresholds_flag%TYPE) IS
85: --------------------------------------------------------------------------------
86: BEGIN

Line 83: p_sh_currency_code OUT NOCOPY ap_pol_headers.currency_code%TYPE,

79: --------------------------------------------------------------------------------
80: PROCEDURE getSchHeaderInfo(
81: p_policy_id IN ap_pol_headers.policy_id%TYPE,
82: p_sh_distance_uom OUT NOCOPY ap_pol_headers.distance_uom%TYPE,
83: p_sh_currency_code OUT NOCOPY ap_pol_headers.currency_code%TYPE,
84: p_sh_distance_thresholds_flag OUT NOCOPY ap_pol_headers.distance_thresholds_flag%TYPE) IS
85: --------------------------------------------------------------------------------
86: BEGIN
87:

Line 84: p_sh_distance_thresholds_flag OUT NOCOPY ap_pol_headers.distance_thresholds_flag%TYPE) IS

80: PROCEDURE getSchHeaderInfo(
81: p_policy_id IN ap_pol_headers.policy_id%TYPE,
82: p_sh_distance_uom OUT NOCOPY ap_pol_headers.distance_uom%TYPE,
83: p_sh_currency_code OUT NOCOPY ap_pol_headers.currency_code%TYPE,
84: p_sh_distance_thresholds_flag OUT NOCOPY ap_pol_headers.distance_thresholds_flag%TYPE) IS
85: --------------------------------------------------------------------------------
86: BEGIN
87:
88: SELECT distance_uom,

Line 94: FROM AP_POL_HEADERS

90: distance_thresholds_flag
91: INTO p_sh_distance_uom,
92: p_sh_currency_code,
93: p_sh_distance_thresholds_flag
94: FROM AP_POL_HEADERS
95: WHERE policy_id = p_policy_id;
96:
97:
98: EXCEPTION