APPS.PAY_SE_ARCHIVE_CWCA dependencies on DUAL

Line 507: FROM DUAL;

503: IF l_asg_effective_end_date <= l_report_end_date THEN
504:
505: SELECT LAST_DAY(l_asg_effective_end_date)
506: INTO l_report_end_date
507: FROM DUAL;
508: ELSE
509:
510: SELECT LAST_DAY(g_effective_date)
511: INTO l_report_end_date

Line 512: FROM DUAL;

508: ELSE
509:
510: SELECT LAST_DAY(g_effective_date)
511: INTO l_report_end_date
512: FROM DUAL;
513:
514: END IF;
515:
516: fnd_file.put_line (fnd_file.LOG, 'l_report_end_date'||to_char(l_report_end_date));

Line 702: --FROM DUAL;

698: LOOP
699:
700: --SELECT last_day(l_report_start_date), LPAD(TO_CHAR(l_report_start_date,'MM'), 2,'0'),TO_CHAR(l_report_start_date,'YYYY')
701: --INTO l_reporting_date, l_month, l_year
702: --FROM DUAL;
703:
704: SELECT last_day(l_report_end_date), LPAD(TO_CHAR(l_report_end_date,'MM'), 2,'0'),TO_CHAR(l_report_end_date,'YYYY')
705: INTO l_reporting_date, l_month, l_year
706: FROM DUAL;

Line 706: FROM DUAL;

702: --FROM DUAL;
703:
704: SELECT last_day(l_report_end_date), LPAD(TO_CHAR(l_report_end_date,'MM'), 2,'0'),TO_CHAR(l_report_end_date,'YYYY')
705: INTO l_reporting_date, l_month, l_year
706: FROM DUAL;
707:
708: IF l_artistic_work = 'Y'
709: THEN
710: OPEN csr_se_wtc_time_worked_info (g_assignment_id,l_year,l_month);

Line 1233: 'select 1 from dual where to_char(:payroll_action_id) = dummy';

1229: EXCEPTION
1230: WHEN OTHERS THEN
1231: -- Return cursor that selects no rows
1232: p_sql :=
1233: 'select 1 from dual where to_char(:payroll_action_id) = dummy';
1234: END range_code;
1235:
1236: /* ASSIGNMENT ACTION CODE */
1237: PROCEDURE assignment_action_code (