APPS.PY_ZA_PRORATE_PKG dependencies on DUAL

Line 50: select to_char(next_date, 'DAY') into days from dual;

46: loop
47:
48: exit when next_date > period_2;
49:
50: select to_char(next_date, 'DAY') into days from dual;
51:
52:
53:
54: If rtrim(days) in ('MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY') then

Line 118: total_days from dual;

114:
115:
116:
117: select get_workdays(start_date,end_date) into
118: total_days from dual;
119: END;
120:
121: BEGIN
122: OPEN C2 (x_payroll_action_id);

Line 132: days_worked from dual;

128: eff_end_date >= start_date and
129: eff_end_date <= end_date then
130:
131: select get_workdays(start_date,eff_end_date) into
132: days_worked from dual;
133:
134: end if;
135:
136: if eff_start_date >= start_date and

Line 139: days_worked from dual;

135:
136: if eff_start_date >= start_date and
137: eff_end_date <= end_date then
138: select get_workdays(eff_start_date,eff_end_date) into
139: days_worked from dual;
140:
141: end if;
142:
143: if eff_start_date >= start_date and

Line 147: days_worked from dual;

143: if eff_start_date >= start_date and
144: eff_start_date <= end_date and
145: eff_end_date > end_date then
146: select get_workdays(eff_start_date,end_date) into
147: days_worked from dual;
148: end if;
149:
150: total_days_worked := total_days_worked + days_worked;
151: days_worked := 0;