APPS.PAY_JP_ISDF_SS_PKG dependencies on DUAL

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

6: --
7: c_isdf_ins_elm constant varchar2(80) := 'YEA_INS_PREM_EXM_DECLARE_INFO';
8: c_isdf_ins_elm_id constant number := hr_jp_id_pkg.element_type_id(c_isdf_ins_elm, null, 'JP');
9: c_life_gen_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'GEN_LIFE_INS_PREM');
10: c_life_pens_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'INDIVIDUAL_PENSION_PREM');
11: c_nonlife_long_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'LONG_TERM_NONLIFE_INS_PREM');
12: c_nonlife_short_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'SHORT_TERM_NONLIFE_INS_PREM');
13: c_earthquake_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'EARTHQUAKE_INS_PREM');
14: c_life_gen_new_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'GEN_LIFE_INS_PREM_2012');

Line 15: c_life_pens_new_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'INDIVIDUAL_PENSION_PREM_2012');

11: c_nonlife_long_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'LONG_TERM_NONLIFE_INS_PREM');
12: c_nonlife_short_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'SHORT_TERM_NONLIFE_INS_PREM');
13: c_earthquake_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'EARTHQUAKE_INS_PREM');
14: c_life_gen_new_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'GEN_LIFE_INS_PREM_2012');
15: c_life_pens_new_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'INDIVIDUAL_PENSION_PREM_2012');
16: c_care_med_new_iv_id constant number := hr_jp_id_pkg.input_value_id(c_isdf_ins_elm_id, 'CARE_INS_PREM_2012');
17:
18: --
19: c_isdf_is_elm constant varchar2(80) := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';

Line 3153: from dual;

3149: if l_csr_calc_dct.action_information_id is null then
3150: --
3151: select pay_action_information_s.nextval
3152: into l_action_information_id
3153: from dual;
3154: --
3155: pay_jp_isdf_dml_pkg.create_calc_dct(
3156: p_action_information_id => l_action_information_id,
3157: p_assignment_action_id => l_assact_rec.assignment_action_id,

Line 3244: from dual;

3240: if l_csr_calc_dct2.action_information_id is null then
3241: --
3242: select pay_action_information_s.nextval
3243: into l_action_information_id
3244: from dual;
3245: --
3246: pay_jp_isdf_dml_pkg.create_calc_dct2(
3247: p_action_information_id => l_action_information_id,
3248: p_assignment_action_id => l_assact_rec.assignment_action_id,

Line 3369: from dual;

3365: if l_csr_calc_dct.action_information_id is null then
3366: --
3367: select pay_action_information_s.nextval
3368: into l_action_information_id
3369: from dual;
3370: --
3371: pay_jp_isdf_dml_pkg.create_calc_dct(
3372: p_action_information_id => l_action_information_id,
3373: p_assignment_action_id => l_assact_rec.assignment_action_id,

Line 3460: from dual;

3456: if l_csr_calc_dct2.action_information_id is null then
3457: --
3458: select pay_action_information_s.nextval
3459: into l_action_information_id
3460: from dual;
3461: --
3462: pay_jp_isdf_dml_pkg.create_calc_dct2(
3463: p_action_information_id => l_action_information_id,
3464: p_assignment_action_id => l_assact_rec.assignment_action_id,

Line 3503: from dual;

3499: if l_csr_entry.action_information_id is null then
3500: --
3501: select pay_action_information_s.nextval
3502: into l_action_information_id
3503: from dual;
3504: --
3505: pay_jp_isdf_dml_pkg.create_entry(
3506: p_action_information_id => l_action_information_id,
3507: p_assignment_action_id => l_assact_rec.assignment_action_id,