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 1921: l_ele_set pay_element_sets.element_set_name%type;

1917: function get_gs_rec_id(
1918: p_rec_name in varchar2)
1919: return number
1920: is
1921: l_ele_set pay_element_sets.element_set_name%type;
1922: l_elm_id number;
1923: l_rslt_id number;
1924: --
1925: cursor csr_ele_set

Line 1928: from pay_element_sets pes

1924: --
1925: cursor csr_ele_set
1926: is
1927: select pes.element_set_id
1928: from pay_element_sets pes
1929: where pes.legislation_code = c_legislation_code
1930: and pes.element_set_name = l_ele_set;
1931: --
1932: begin