DBA Data[Home] [Help]

APPS.PAY_JP_REPORT_PKG dependencies on PAY_ELEMENT_SETS

Line 30: c_san_ele_set pay_element_sets.element_set_name%type := 'SAN';

26: c_wp_num_iv pay_input_values_f.name%type := 'WP_SERIAL_NUM';
27: c_bp_num_iv pay_input_values_f.name%type := 'BASIC_PENSION_NUM';
28: c_com_si_rep_elm pay_element_types_f.element_name%type := 'COM_SI_REPORT_INFO';
29: c_exc_iv pay_input_values_f.name%type := 'OUTPUT_FLAG';
30: c_san_ele_set pay_element_sets.element_set_name%type := 'SAN';
31: c_gep_ele_set pay_element_sets.element_set_name%type := 'GEP';
32: c_iku_ele_set pay_element_sets.element_set_name%type := 'IKU';
33: --
34: c_com_hi_q_info_elm pay_element_types_f.element_name%type := 'COM_HI_QUALIFY_INFO';

Line 31: c_gep_ele_set pay_element_sets.element_set_name%type := 'GEP';

27: c_bp_num_iv pay_input_values_f.name%type := 'BASIC_PENSION_NUM';
28: c_com_si_rep_elm pay_element_types_f.element_name%type := 'COM_SI_REPORT_INFO';
29: c_exc_iv pay_input_values_f.name%type := 'OUTPUT_FLAG';
30: c_san_ele_set pay_element_sets.element_set_name%type := 'SAN';
31: c_gep_ele_set pay_element_sets.element_set_name%type := 'GEP';
32: c_iku_ele_set pay_element_sets.element_set_name%type := 'IKU';
33: --
34: c_com_hi_q_info_elm pay_element_types_f.element_name%type := 'COM_HI_QUALIFY_INFO';
35: c_com_wp_q_info_elm pay_element_types_f.element_name%type := 'COM_WP_QUALIFY_INFO';

Line 32: c_iku_ele_set pay_element_sets.element_set_name%type := 'IKU';

28: c_com_si_rep_elm pay_element_types_f.element_name%type := 'COM_SI_REPORT_INFO';
29: c_exc_iv pay_input_values_f.name%type := 'OUTPUT_FLAG';
30: c_san_ele_set pay_element_sets.element_set_name%type := 'SAN';
31: c_gep_ele_set pay_element_sets.element_set_name%type := 'GEP';
32: c_iku_ele_set pay_element_sets.element_set_name%type := 'IKU';
33: --
34: c_com_hi_q_info_elm pay_element_types_f.element_name%type := 'COM_HI_QUALIFY_INFO';
35: c_com_wp_q_info_elm pay_element_types_f.element_name%type := 'COM_WP_QUALIFY_INFO';
36: c_com_wpf_q_info_elm pay_element_types_f.element_name%type := 'COM_WPF_QUALIFY_INFO';

Line 1912: l_ele_set pay_element_sets.element_set_name%type;

1908: function get_gs_rec_id(
1909: p_rec_name in varchar2)
1910: return number
1911: is
1912: l_ele_set pay_element_sets.element_set_name%type;
1913: l_elm_id number;
1914: l_rslt_id number;
1915: --
1916: cursor csr_ele_set

Line 1919: from pay_element_sets pes

1915: --
1916: cursor csr_ele_set
1917: is
1918: select pes.element_set_id
1919: from pay_element_sets pes
1920: where pes.legislation_code = c_legislation_code
1921: and pes.element_set_name = l_ele_set;
1922: --
1923: begin