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 122: total_days from dual;

118:
119:
120:
121: select get_workdays(start_date,end_date) into
122: total_days from dual;
123: END;
124:
125: BEGIN
126: OPEN C2 (x_payroll_action_id,x_assignment_id);

Line 136: days_worked from dual;

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

Line 143: days_worked from dual;

139:
140: if eff_start_date >= start_date and
141: eff_end_date <= end_date then
142: select get_workdays(eff_start_date,eff_end_date) into
143: days_worked from dual;
144:
145: end if;
146:
147: if eff_start_date >= start_date and

Line 151: days_worked from dual;

147: if eff_start_date >= start_date and
148: eff_start_date <= end_date and
149: eff_end_date > end_date then
150: select get_workdays(eff_start_date,end_date) into
151: days_worked from dual;
152: end if;
153:
154: total_days_worked := total_days_worked + days_worked;
155: days_worked := 0;