APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on DUAL

Line 1137: FROM DUAL;

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

Line 1940: FROM DUAL;

1936: 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');
1937:
1938: SELECT last_day(l_report_start_date)
1939: INTO l_reporting_date
1940: FROM DUAL;
1941:
1942: fnd_file.put_line (fnd_file.LOG, 'l_reporting_date'||l_reporting_date);
1943:
1944: l_overtime_hours :=0;

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

2290: WHEN OTHERS
2291: THEN
2292: -- Return cursor that selects no rows
2293: p_sql :=
2294: 'select 1 from dual where to_char(:payroll_action_id) = dummy'; */
2295: END range_code;
2296:
2297: /* ASSIGNMENT ACTION CODE */
2298: PROCEDURE assignment_action_code (

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

2662: END loop;
2663:
2664: WHILE l_number >= 1 LOOP
2665:
2666: SELECT mod(l_number,10) INTO l_digit(l_count) from dual;
2667: l_number:=floor(l_number/10);
2668: l_count:=l_count+1;
2669: END LOOP;
2670:

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

2667: l_number:=floor(l_number/10);
2668: l_count:=l_count+1;
2669: END LOOP;
2670:
2671: SELECT floor(l_number) INTO l_digit(l_number) from dual;
2672: p_digit1:=l_digit(1);
2673: p_digit2:=l_digit(2);
2674: p_digit3:=l_digit(3);
2675: p_digit4:=l_digit(4);

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

3012:
3013:
3014:
3015: -- *****************************************************************************
3016: -- Add Individual Months Overtime and Addl/Supplemtary hours
3017: -- *****************************************************************************
3018: CURSOR csr_wtc_get_ovr_addl_val (
3019: csr_v_pa_id pay_action_information.action_context_id%TYPE
3020: ,csr_v_group_id pay_action_information.action_information28%TYPE

Line 3061: -- Add Individual Months Absence hours

3057:
3058:
3059:
3060: -- *****************************************************************************
3061: -- Add Individual Months Absence hours
3062: -- *****************************************************************************
3063: CURSOR csr_wtc_get_absence_val (
3064: csr_v_pa_id pay_action_information.action_context_id%TYPE
3065: ,csr_v_group_id pay_action_information.action_information28%TYPE

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

4265: add_tag_value ('OTHERYEAR', 'OTHERYEAR');
4266: END IF;
4267:
4268: -- *****************************************************************************
4269: -- Add code to put individual month value
4270: -- for each group id we will get two years value i.e.. two rows
4271: -- *****************************************************************************
4272: FOR rec_wtc_get_month_value IN
4273: csr_wtc_get_month_value (l_payroll_action_id

Line 4288: -- Add Individual Months days and hours

4284: add_tag_value ('SECONDYEAR', 'SECONDYEAR');
4285: END IF;
4286:
4287: -- *****************************************************************************
4288: -- Add Individual Months days and hours
4289: -- *****************************************************************************
4290: add_tag_value ('YEAR', rec_wtc_get_month_value.YEAR);
4291: add_tag_value ('JAN_DAYS', rec_wtc_get_month_value.jan_days);
4292: add_tag_value ('FEB_DAYS', rec_wtc_get_month_value.feb_days);

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

4327:
4328: -- *****************************************************************************
4329: --------------Code for EOY 2008 changes
4330: -- *****************************************************************************
4331: -- Add code to put individual month value for absence
4332: -- for each group id we will get two years value i.e.. two rows
4333: -- *****************************************************************************
4334: FOR rec_wtc_get_ovr_addl_val IN
4335: csr_wtc_get_ovr_addl_val (l_payroll_action_id

Line 4350: -- Add Individual Months days and hours

4346: add_tag_value ('SECONDYEAR', 'SECONDYEAR');
4347: END IF;
4348:
4349: -- *****************************************************************************
4350: -- Add Individual Months days and hours
4351: -- *****************************************************************************
4352: add_tag_value ('YEAR', rec_wtc_get_ovr_addl_val.YEAR);
4353: add_tag_value ('JAN_ADDL', rec_wtc_get_ovr_addl_val.jan_addl_time);
4354: add_tag_value ('FEB_ADDL', rec_wtc_get_ovr_addl_val.feb_addl_time);

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

4386: END IF;
4387: -- *****************************************************************************
4388: END LOOP;
4389: -- *****************************************************************************
4390: -- Add code to put individual month value
4391: -- for each group id we will get two years value i.e.. two rows
4392: -- *****************************************************************************
4393: FOR rec_wtc_get_absence_val IN
4394: csr_wtc_get_absence_val (l_payroll_action_id

Line 4409: -- Add Individual Months days and hours

4405: add_tag_value ('SECONDYEAR', 'SECONDYEAR');
4406: END IF;
4407:
4408: -- *****************************************************************************
4409: -- Add Individual Months days and hours
4410: -- *****************************************************************************
4411: add_tag_value ('YEAR', rec_wtc_get_absence_val.YEAR);
4412: add_tag_value ('JAN_ABSENCE', rec_wtc_get_absence_val.jan_absence_time);
4413: add_tag_value ('FEB_ABSENCE', rec_wtc_get_absence_val.feb_absence_time);