APPS.AP_WEB_DB_SCHLINE_PKG dependencies on AP_POL_HEADERS

Line 30: FROM AP_POL_HEADERS SH,

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

Line 66: p_policy_id IN ap_pol_headers.policy_id%TYPE,

62:
63:
64: --------------------------------------------------------------------------------
65: PROCEDURE getSchHeaderInfo(
66: p_policy_id IN ap_pol_headers.policy_id%TYPE,
67: p_sh_distance_uom OUT NOCOPY ap_pol_headers.distance_uom%TYPE,
68: p_sh_currency_code OUT NOCOPY ap_pol_headers.currency_code%TYPE,
69: p_sh_distance_thresholds_flag OUT NOCOPY ap_pol_headers.distance_thresholds_flag%TYPE) IS
70: --------------------------------------------------------------------------------

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

63:
64: --------------------------------------------------------------------------------
65: PROCEDURE getSchHeaderInfo(
66: p_policy_id IN ap_pol_headers.policy_id%TYPE,
67: p_sh_distance_uom OUT NOCOPY ap_pol_headers.distance_uom%TYPE,
68: p_sh_currency_code OUT NOCOPY ap_pol_headers.currency_code%TYPE,
69: p_sh_distance_thresholds_flag OUT NOCOPY ap_pol_headers.distance_thresholds_flag%TYPE) IS
70: --------------------------------------------------------------------------------
71: BEGIN

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

64: --------------------------------------------------------------------------------
65: PROCEDURE getSchHeaderInfo(
66: p_policy_id IN ap_pol_headers.policy_id%TYPE,
67: p_sh_distance_uom OUT NOCOPY ap_pol_headers.distance_uom%TYPE,
68: p_sh_currency_code OUT NOCOPY ap_pol_headers.currency_code%TYPE,
69: p_sh_distance_thresholds_flag OUT NOCOPY ap_pol_headers.distance_thresholds_flag%TYPE) IS
70: --------------------------------------------------------------------------------
71: BEGIN
72:

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

65: PROCEDURE getSchHeaderInfo(
66: p_policy_id IN ap_pol_headers.policy_id%TYPE,
67: p_sh_distance_uom OUT NOCOPY ap_pol_headers.distance_uom%TYPE,
68: p_sh_currency_code OUT NOCOPY ap_pol_headers.currency_code%TYPE,
69: p_sh_distance_thresholds_flag OUT NOCOPY ap_pol_headers.distance_thresholds_flag%TYPE) IS
70: --------------------------------------------------------------------------------
71: BEGIN
72:
73: SELECT distance_uom,

Line 79: FROM AP_POL_HEADERS

75: distance_thresholds_flag
76: INTO p_sh_distance_uom,
77: p_sh_currency_code,
78: p_sh_distance_thresholds_flag
79: FROM AP_POL_HEADERS
80: WHERE policy_id = p_policy_id;
81:
82:
83: EXCEPTION

Line 107: AP_POL_HEADERS SH,

103:
104: SELECT decode(SH.EMPLOYEE_ROLE_FLAG,'Y',
105: (decode(SH.ROLE_CODE,'JOB_GROUP', PF.job_id,'POSITION',PF.position_id,'GRADE',PF.grade_id,0)),0) INTO l_role_code
106: FROM
107: AP_POL_HEADERS SH,
108: (SELECT EMP.ASSIGNMENT_ID ,EMP.EMPLOYEE_ID
109: FROM PER_EMPLOYEES_X EMP
110: WHERE NOT AP_WEB_DB_HR_INT_PKG.ISPERSONCWK(EMP.EMPLOYEE_ID)= 'Y'
111: AND EMP.EMPLOYEE_ID = p_employee_id