APPS.PER_ZA_UTILITY_PKG dependencies on DUAL

Line 527: FROM dual;

523: hr_utility.set_location('per_za_utility_pkg.insert_ipv_link',1);
524: -- get link_input_value_id from the sequence
525: SELECT pay_link_input_values_s.nextval
526: INTO l_link_input_pk
527: FROM dual;
528: hr_utility.set_location('per_za_utility_pkg.insert_ipv_link',2);
529: INSERT
530: INTO pay_link_input_values_f
531: ( link_input_value_id

Line 599: FROM dual;

595: hr_utility.set_location('per_za_utility_pkg.insert_ee_value',1);
596: -- Get the element_entry_value_id from the sequence
597: SELECT pay_element_entry_values_s.nextval
598: INTO l_entry_value_pk
599: FROM dual;
600: hr_utility.set_location('per_za_utility_pkg.insert_ee_value',2);
601: -- Insert a new row using the sequence value
602: INSERT
603: INTO pay_element_entry_values_f

Line 965: from dual

961: (select
962: p_input_value_id
963: ,p_run_result_id
964: ,p_result_value
965: from dual
966: where not exists ( select null
967: from pay_run_result_values
968: where INPUT_VALUE_ID = p_input_value_id
969: and run_result_id = p_run_result_id

Line 989: from dual

985: (select cur_run_res_con_rec.assignment_action_id
986: ,cur_run_res_con_rec.assignment_id
987: ,l_Dir_no_con
988: ,l_dir_no
989: from dual
990: where not exists (select null
991: from pay_action_contexts
992: where assignment_action_id = cur_run_res_con_rec.assignment_action_id
993: and assignment_id = cur_run_res_con_rec.assignment_id

Line 1015: from dual

1011: (select cur_run_res_con_rec.assignment_action_id
1012: ,cur_run_res_con_rec.assignment_id
1013: ,l_clar_no_con
1014: ,l_clar_no
1015: from dual
1016: where not exists (select null
1017: from pay_action_contexts
1018: where assignment_action_id = cur_run_res_con_rec.assignment_action_id
1019: and assignment_id = cur_run_res_con_rec.assignment_id