APPS.PAY_CA_USER_INIT_EARN dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 304: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

300: l_object_version_number NUMBER(9); -- Object Version Number
301: l_sep_check_create VARCHAR2(1);
302:
303: l_bg_name VARCHAR2(60); -- Get from bg short name passed in.
304: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
305: l_ele_obj_ver_number NUMBER(9); -- Object Version Number
306: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
307: l_sf_ele_obj_ver_number NUMBER(9); -- Object Version Number
308: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

Line 306: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

302:
303: l_bg_name VARCHAR2(60); -- Get from bg short name passed in.
304: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
305: l_ele_obj_ver_number NUMBER(9); -- Object Version Number
306: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
307: l_sf_ele_obj_ver_number NUMBER(9); -- Object Version Number
308: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
309: l_si_ele_obj_ver_number NUMBER(9); -- Object Version Number
310: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.

Line 308: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

304: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
305: l_ele_obj_ver_number NUMBER(9); -- Object Version Number
306: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
307: l_sf_ele_obj_ver_number NUMBER(9); -- Object Version Number
308: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
309: l_si_ele_obj_ver_number NUMBER(9); -- Object Version Number
310: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.
311: l_pay_value_iv_id NUMBER(9); --
312: l_balance_feed_id NUMBER(9); --

Line 526: from pay_shadow_element_types

522: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',6);
523: --
524: select element_type_id, object_version_number
525: into l_element_type_id, l_ele_obj_ver_number
526: from pay_shadow_element_types
527: where template_id = l_template_id
528: and element_name = p_ele_name;
529: --
530: -- NTG elements do not have SF nor SI elements.

Line 536: from pay_shadow_element_types

532:
533: if p_ele_calc_rule_code <> 'NTG FLT' then
534: select element_type_id, object_version_number
535: into l_sf_element_type_id, l_sf_ele_obj_ver_number
536: from pay_shadow_element_types
537: where template_id = l_template_id
538: and element_name = p_ele_name||' Special Features';
539: end if;
540: --

Line 544: from pay_shadow_element_types

540: --
541: if (p_ele_processing_type = 'R') and (p_ele_calc_rule_code <> 'NTG FLT') then
542: select element_type_id, object_version_number
543: into l_si_element_type_id, l_si_ele_obj_ver_number
544: from pay_shadow_element_types
545: where template_id = l_template_id
546: and element_name = p_ele_name||' Special Inputs';
547: end if;
548: --