APPS.PQP_GB_CSS_DAILY_ABSENCES dependencies on PQP_GAP_DAILY_ABSENCES

Line 14: g_pt_rounding_precision pqp_gap_daily_absences.duration%TYPE;

10: -- g_plan_information pqp_absval_pkg.rec_plan_information ;
11: g_debug BOOLEAN ;
12: -- Cache for rounding of factors
13: g_pt_entitl_rounding_type VARCHAR2(10):=null;
14: g_pt_rounding_precision pqp_gap_daily_absences.duration%TYPE;
15: g_ft_rounding_precision pqp_gap_daily_absences.duration%TYPE;
16: g_ft_entitl_rounding_type VARCHAR2(10):=null ;
17: g_open_ended_no_pay_days NUMBER;
18:

Line 15: g_ft_rounding_precision pqp_gap_daily_absences.duration%TYPE;

11: g_debug BOOLEAN ;
12: -- Cache for rounding of factors
13: g_pt_entitl_rounding_type VARCHAR2(10):=null;
14: g_pt_rounding_precision pqp_gap_daily_absences.duration%TYPE;
15: g_ft_rounding_precision pqp_gap_daily_absences.duration%TYPE;
16: g_ft_entitl_rounding_type VARCHAR2(10):=null ;
17: g_open_ended_no_pay_days NUMBER;
18:
19: PROCEDURE debug

Line 101: pqp_gap_daily_absences.working_days_per_week%TYPE ;

97: l_total_remaining NUMBER ;
98: l_fullpay_duration NUMBER ;
99: l_error_message fnd_new_messages.message_text%TYPE;
100: l_working_days_in_week
101: pqp_gap_daily_absences.working_days_per_week%TYPE ;
102: i NUMBER ;
103:
104: l_entitlements_remaining_nc pqp_absval_pkg.t_entitlements
105: := p_entitlements_remaining;

Line 107: l_working_days_per_week_nc pqp_gap_daily_absences.working_days_per_week%TYPE

103:
104: l_entitlements_remaining_nc pqp_absval_pkg.t_entitlements
105: := p_entitlements_remaining;
106: l_entitlement_UOM_nc VARCHAR2(30) := p_entitlement_UOM ;
107: l_working_days_per_week_nc pqp_gap_daily_absences.working_days_per_week%TYPE
108: := p_working_days_per_week;
109: l_standard_work_days_in_week
110: pqp_gap_daily_absences.working_days_per_week%TYPE ;
111: l_fulltime BOOLEAN ;

Line 110: pqp_gap_daily_absences.working_days_per_week%TYPE ;

106: l_entitlement_UOM_nc VARCHAR2(30) := p_entitlement_UOM ;
107: l_working_days_per_week_nc pqp_gap_daily_absences.working_days_per_week%TYPE
108: := p_working_days_per_week;
109: l_standard_work_days_in_week
110: pqp_gap_daily_absences.working_days_per_week%TYPE ;
111: l_fulltime BOOLEAN ;
112:
113: BEGIN
114:

Line 915: from pqp_gap_daily_absences gda

911: -- This cursor gets the NOPAID days only
912: -- for Civil Service Scheme, as in 4 years
913: CURSOR csr_css_no_pay_days IS
914: select NVL(SUM(gda.duration),0)
915: from pqp_gap_daily_absences gda
916: ,pqp_gap_absence_plans gap
917: ,ben_pl_f pl
918: where pl.pl_id = gap.pl_id
919: and pl.pl_typ_id = p_pl_typ_id