APPS.PAY_CA_USER_INIT_EARN dependencies on PAY_SHADOW_ELEMENT_TYPES

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

295: l_object_version_number NUMBER(9); -- Object Version Number
296: l_sep_check_create VARCHAR2(1);
297:
298: l_bg_name VARCHAR2(60); -- Get from bg short name passed in.
299: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
300: l_ele_obj_ver_number NUMBER(9); -- Object Version Number
301: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
302: l_sf_ele_obj_ver_number NUMBER(9); -- Object Version Number
303: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

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

297:
298: l_bg_name VARCHAR2(60); -- Get from bg short name passed in.
299: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
300: l_ele_obj_ver_number NUMBER(9); -- Object Version Number
301: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
302: l_sf_ele_obj_ver_number NUMBER(9); -- Object Version Number
303: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
304: l_si_ele_obj_ver_number NUMBER(9); -- Object Version Number
305: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.

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

299: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
300: l_ele_obj_ver_number NUMBER(9); -- Object Version Number
301: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
302: l_sf_ele_obj_ver_number NUMBER(9); -- Object Version Number
303: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
304: l_si_ele_obj_ver_number NUMBER(9); -- Object Version Number
305: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.
306: l_pay_value_iv_id NUMBER(9); --
307: l_balance_feed_id NUMBER(9); --

Line 521: from pay_shadow_element_types

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

Line 531: from pay_shadow_element_types

527:
528: if p_ele_calc_rule_code <> 'NTG FLT' then
529: select element_type_id, object_version_number
530: into l_sf_element_type_id, l_sf_ele_obj_ver_number
531: from pay_shadow_element_types
532: where template_id = l_template_id
533: and element_name = p_ele_name||' Special Features';
534: end if;
535: --

Line 539: from pay_shadow_element_types

535: --
536: if (p_ele_processing_type = 'R') and (p_ele_calc_rule_code <> 'NTG FLT') then
537: select element_type_id, object_version_number
538: into l_si_element_type_id, l_si_ele_obj_ver_number
539: from pay_shadow_element_types
540: where template_id = l_template_id
541: and element_name = p_ele_name||' Special Inputs';
542: end if;
543: --