APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on DUAL

Line 17: c_life_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'INDIVIDUAL_PENSION_PREM');

13: c_tax_type_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itax_info_elm_id, 'ITX_TYPE');
14: --
15: c_isdf_ins_elm_id constant number := hr_jp_id_pkg.element_type_id('YEA_INS_PREM_EXM_DECLARE_INFO', null, 'JP');
16: c_life_gen_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'GEN_LIFE_INS_PREM');
17: c_life_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'INDIVIDUAL_PENSION_PREM');
18: c_nonlife_long_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'LONG_TERM_NONLIFE_INS_PREM');
19: c_nonlife_short_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'SHORT_TERM_NONLIFE_INS_PREM');
20: c_earthquake_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'EARTHQUAKE_INS_PREM');
21: --

Line 309: from dual

305: end if;
306: --
307: p_sqlstr :=
308: 'select 1
309: from dual
310: where :payroll_action_id < 0';
311: --
312: else
313: --

Line 459: from dual;

455: end if;
456: --
457: select pay_assignment_actions_s.nextval
458: into l_assignment_action_id
459: from dual;
460: --
461: hr_nonrun_asact.insact(
462: lockingactid => l_assignment_action_id,
463: assignid => l_assignment_id,

Line 918: --from dual

914: --
915: --cursor csr_future_exists
916: --is
917: --select 'Y'
918: --from dual
919: --where exists(
920: -- select null
921: -- from pay_element_entries_f
922: -- where element_entry_id = p_element_entry_id