APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on DUAL

Line 1135: FROM DUAL;

1131: l_report_start_date := TO_DATE('01/'||l_currentmonth||'/'||l_currentyear,'DD/MM/YYYY');
1132:
1133: SELECT last_day(l_report_start_date)
1134: INTO l_reporting_date
1135: FROM DUAL;
1136:
1137: -- fnd_file.put_line (fnd_file.LOG, 'l_reporting_date' ||l_reporting_date);
1138:
1139: l_overtime_hours :=0;

Line 1918: FROM DUAL;

1914: l_report_start_date := TO_DATE('01/'||lr_se_wtc_time_worked_info.aei_information2||'/'||lr_se_wtc_time_worked_info.aei_information1,'DD/MM/YYYY');
1915:
1916: SELECT last_day(l_report_start_date)
1917: INTO l_reporting_date
1918: FROM DUAL;
1919:
1920: fnd_file.put_line (fnd_file.LOG, 'l_reporting_date'||l_reporting_date);
1921:
1922: l_overtime_hours :=0;

Line 2254: 'select 1 from dual where to_char(:payroll_action_id) = dummy'; */

2250: WHEN OTHERS
2251: THEN
2252: -- Return cursor that selects no rows
2253: p_sql :=
2254: 'select 1 from dual where to_char(:payroll_action_id) = dummy'; */
2255: END range_code;
2256:
2257: /* ASSIGNMENT ACTION CODE */
2258: PROCEDURE assignment_action_code (

Line 2626: SELECT mod(l_number,10) INTO l_digit(l_count) from dual;

2622: END loop;
2623:
2624: WHILE l_number >= 1 LOOP
2625:
2626: SELECT mod(l_number,10) INTO l_digit(l_count) from dual;
2627: l_number:=floor(l_number/10);
2628: l_count:=l_count+1;
2629: END LOOP;
2630:

Line 2631: SELECT floor(l_number) INTO l_digit(l_number) from dual;

2627: l_number:=floor(l_number/10);
2628: l_count:=l_count+1;
2629: END LOOP;
2630:
2631: SELECT floor(l_number) INTO l_digit(l_number) from dual;
2632: p_digit1:=l_digit(1);
2633: p_digit2:=l_digit(2);
2634: p_digit3:=l_digit(3);
2635: p_digit4:=l_digit(4);

Line 2976: -- Add Individual Months Overtime and Addl/Supplemtary hours

2972:
2973:
2974:
2975: -- *****************************************************************************
2976: -- Add Individual Months Overtime and Addl/Supplemtary hours
2977: -- *****************************************************************************
2978: CURSOR csr_wtc_get_ovr_addl_val (
2979: csr_v_pa_id pay_action_information.action_context_id%TYPE
2980: ,csr_v_group_id pay_action_information.action_information28%TYPE

Line 3021: -- Add Individual Months Absence hours

3017:
3018:
3019:
3020: -- *****************************************************************************
3021: -- Add Individual Months Absence hours
3022: -- *****************************************************************************
3023: CURSOR csr_wtc_get_absence_val (
3024: csr_v_pa_id pay_action_information.action_context_id%TYPE
3025: ,csr_v_group_id pay_action_information.action_information28%TYPE

Line 4228: -- Add code to put individual month value

4224: add_tag_value ('OTHERYEAR', 'OTHERYEAR');
4225: END IF;
4226:
4227: -- *****************************************************************************
4228: -- Add code to put individual month value
4229: -- for each group id we will get two years value i.e.. two rows
4230: -- *****************************************************************************
4231: FOR rec_wtc_get_month_value IN
4232: csr_wtc_get_month_value (l_payroll_action_id

Line 4247: -- Add Individual Months days and hours

4243: add_tag_value ('SECONDYEAR', 'SECONDYEAR');
4244: END IF;
4245:
4246: -- *****************************************************************************
4247: -- Add Individual Months days and hours
4248: -- *****************************************************************************
4249: add_tag_value ('YEAR', rec_wtc_get_month_value.YEAR);
4250: add_tag_value ('JAN_DAYS', rec_wtc_get_month_value.jan_days);
4251: add_tag_value ('FEB_DAYS', rec_wtc_get_month_value.feb_days);

Line 4290: -- Add code to put individual month value for absence

4286:
4287: -- *****************************************************************************
4288: --------------Code for EOY 2008 changes
4289: -- *****************************************************************************
4290: -- Add code to put individual month value for absence
4291: -- for each group id we will get two years value i.e.. two rows
4292: -- *****************************************************************************
4293: FOR rec_wtc_get_ovr_addl_val IN
4294: csr_wtc_get_ovr_addl_val (l_payroll_action_id

Line 4309: -- Add Individual Months days and hours

4305: add_tag_value ('SECONDYEAR', 'SECONDYEAR');
4306: END IF;
4307:
4308: -- *****************************************************************************
4309: -- Add Individual Months days and hours
4310: -- *****************************************************************************
4311: add_tag_value ('YEAR', rec_wtc_get_ovr_addl_val.YEAR);
4312: add_tag_value ('JAN_ADDL', rec_wtc_get_ovr_addl_val.jan_addl_time);
4313: add_tag_value ('FEB_ADDL', rec_wtc_get_ovr_addl_val.feb_addl_time);

Line 4349: -- Add code to put individual month value

4345: END IF;
4346: -- *****************************************************************************
4347: END LOOP;
4348: -- *****************************************************************************
4349: -- Add code to put individual month value
4350: -- for each group id we will get two years value i.e.. two rows
4351: -- *****************************************************************************
4352: FOR rec_wtc_get_absence_val IN
4353: csr_wtc_get_absence_val (l_payroll_action_id

Line 4368: -- Add Individual Months days and hours

4364: add_tag_value ('SECONDYEAR', 'SECONDYEAR');
4365: END IF;
4366:
4367: -- *****************************************************************************
4368: -- Add Individual Months days and hours
4369: -- *****************************************************************************
4370: add_tag_value ('YEAR', rec_wtc_get_absence_val.YEAR);
4371: add_tag_value ('JAN_ABSENCE', rec_wtc_get_absence_val.jan_absence_time);
4372: add_tag_value ('FEB_ABSENCE', rec_wtc_get_absence_val.feb_absence_time);