APPS.PAY_FI_ARCHIVE_UMFR dependencies on DUAL

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

572: WHEN OTHERS
573: THEN
574: -- Return cursor that selects no rows
575: p_sql :=
576: 'select 1 from dual where to_char(:payroll_action_id) = dummy';
577: END range_code;
578:
579: /* ASSIGNMENT ACTION CODE */
580: PROCEDURE assignment_action_code (

Line 901: FROM DUAL;

897: 'BIWEEK', g_period_end_date - 14,
898: 'QUARTER', TRUNC (g_period_end_date, 'Q')
899: )
900: INTO g_period_start_date
901: FROM DUAL;
902:
903: fnd_file.put_line (
904: fnd_file.LOG,
905: 'G_PERIOD_start_DATE '

Line 931: FROM DUAL;

927: if l_assignment <> rec_prepaid_assignments.assignment_id then
928: -- THEN
929: SELECT pay_assignment_actions_s.NEXTVAL
930: INTO l_actid
931: FROM DUAL;
932:
933: --
934: g_index_assact := g_index_assact
935: + 1;