APPS.PAY_JP_UITE_ARCH_PKG dependencies on PAY_ELEMENT_SETS

Line 75: gn_sal_ele_set_id pay_element_sets.element_set_id%TYPE;

71: gd_start_date DATE;
72: gc_exception EXCEPTION;
73: gc_santei_base VARCHAR2(20) DEFAULT gc_date_earned;
74: gn_output_period NUMBER DEFAULT 12;
75: gn_sal_ele_set_id pay_element_sets.element_set_id%TYPE;
76: gn_spb_ele_set_id pay_element_sets.element_set_id%TYPE;
77: --
78: TYPE gt_wage_info IS RECORD (payment_date DATE
79: ,insured_start_date DATE

Line 76: gn_spb_ele_set_id pay_element_sets.element_set_id%TYPE;

72: gc_exception EXCEPTION;
73: gc_santei_base VARCHAR2(20) DEFAULT gc_date_earned;
74: gn_output_period NUMBER DEFAULT 12;
75: gn_sal_ele_set_id pay_element_sets.element_set_id%TYPE;
76: gn_spb_ele_set_id pay_element_sets.element_set_id%TYPE;
77: --
78: TYPE gt_wage_info IS RECORD (payment_date DATE
79: ,insured_start_date DATE
80: ,insured_end_date DATE

Line 474: FROM pay_element_sets PES

470: --
471: CURSOR csr_ele_set
472: IS
473: SELECT MIN(pes.element_set_id)
474: FROM pay_element_sets PES
475: WHERE PES.element_set_name = p_element_set_name
476: AND NVL(PES.business_group_id,p_business_group_id) = p_business_group_id
477: AND NVL(PES.legislation_code,p_legislation_code) = p_legislation_code;
478: --