DBA Data[Home] [Help]

APPS.HR_DU_DP_PC_CONVERSION dependencies on DUAL

Line 1644: FROM dual;

1640: WHERE upload_line_id = l_upload_line_id;
1641:
1642: Select HR_DU_UPLOAD_LINES_S.nextval
1643: INTO l_line_id
1644: FROM dual;
1645:
1646: Select ORIGINAL_UPLOAD_HEADER_ID
1647: INTO l_original_upload_header_id
1648: FROM hr_du_upload_lines

Line 1676: FROM dual;

1672: --grab the sysdate and formate it to the correct style to be executed later
1673: SELECT ' to_date(''' || to_char(sysdate, 'YYYY/MM/DD') ||
1674: ''' , ''YYYY/MM/DD'' ) '
1675: INTO l_date_string
1676: FROM dual;
1677:
1678: --Increment the maximum current value R_ID_CURVAL for the api_module stored
1679: --in the PL/SQL table
1680: g_insert_table(p_target_api_module).r_id_curval :=