APPS.PAY_SE_ARCHIVE_CWCA dependencies on DUAL

Line 504: FROM DUAL;

500: IF l_asg_effective_end_date <= l_report_end_date THEN
501:
502: SELECT LAST_DAY(l_asg_effective_end_date)
503: INTO l_report_end_date
504: FROM DUAL;
505: ELSE
506:
507: SELECT LAST_DAY(g_effective_date)
508: INTO l_report_end_date

Line 509: FROM DUAL;

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

Line 694: --FROM DUAL;

690: LOOP
691:
692: --SELECT last_day(l_report_start_date), LPAD(TO_CHAR(l_report_start_date,'MM'), 2,'0'),TO_CHAR(l_report_start_date,'YYYY')
693: --INTO l_reporting_date, l_month, l_year
694: --FROM DUAL;
695:
696: SELECT last_day(l_report_end_date), LPAD(TO_CHAR(l_report_end_date,'MM'), 2,'0'),TO_CHAR(l_report_end_date,'YYYY')
697: INTO l_reporting_date, l_month, l_year
698: FROM DUAL;

Line 698: FROM DUAL;

694: --FROM DUAL;
695:
696: SELECT last_day(l_report_end_date), LPAD(TO_CHAR(l_report_end_date,'MM'), 2,'0'),TO_CHAR(l_report_end_date,'YYYY')
697: INTO l_reporting_date, l_month, l_year
698: FROM DUAL;
699:
700: IF l_artistic_work = 'Y'
701: THEN
702: OPEN csr_se_wtc_time_worked_info (g_assignment_id,l_year,l_month);

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

1166: EXCEPTION
1167: WHEN OTHERS THEN
1168: -- Return cursor that selects no rows
1169: p_sql :=
1170: 'select 1 from dual where to_char(:payroll_action_id) = dummy';
1171: END range_code;
1172:
1173: /* ASSIGNMENT ACTION CODE */
1174: PROCEDURE assignment_action_code (