APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on DUAL

Line 179: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';

175: OPEN csr_utv_check(g_business_group_id, g_reporting_date);
176: FETCH csr_utv_check INTO l_exsist;
177: IF csr_utv_check%NOTFOUND THEN
178: --
179: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';
180: -- Message to written to log file.
181: fnd_file.put_line(fnd_file.log,fnd_message.get_string('PER'
182: ,'HR_HU_ABS_REP_UDT_VALUE'));
183: --

Line 198: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';

194: CLOSE csr_utv_check;
195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';
199: END range_code;
200:
201: --------------------------------------------------------------------------------
202: -- ACTION_CREATION_CODE

Line 886: FROM dual;

882:
883: --
884: SELECT pay_assignment_actions_s.NEXTVAL
885: INTO l_actid
886: FROM dual;
887: --
888: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,p_actid,chunk,NULL);
889: --
890: pay_action_information_api.create_action_information (