APPS.PQP_GB_PROFESSIONAL_BODY_TEMP dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 71: l_eei_information3 pay_element_type_extra_info.eei_information3%TYPE;

67: l_iv_core_id pay_template_core_objects.core_object_id%TYPE;
68: l_dm_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;
69:
70: -- Extra Information variables
71: l_eei_information3 pay_element_type_extra_info.eei_information3%TYPE;
72: l_eei_information4 pay_element_type_extra_info.eei_information4%TYPE;
73:
74: --
75:

Line 72: l_eei_information4 pay_element_type_extra_info.eei_information4%TYPE;

68: l_dm_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;
69:
70: -- Extra Information variables
71: l_eei_information3 pay_element_type_extra_info.eei_information3%TYPE;
72: l_eei_information4 pay_element_type_extra_info.eei_information4%TYPE;
73:
74: --
75:
76: TYPE t_dim IS TABLE OF VARCHAR2(80)

Line 642: FROM pay_element_type_extra_info petei

638: l_del_pbd_level_balance_yn varchar2(1) := 'Y';
639: --
640: CURSOR eei is
641: SELECT element_type_extra_info_id
642: FROM pay_element_type_extra_info petei
643: WHERE element_type_id = p_ele_type_id ;
644:
645:
646: CURSOR csr_get_template_id is

Line 669: ,pay_element_type_extra_info peei

665: SELECT TO_NUMBER(peei.eei_information1) pbd_org_id
666: FROM pay_element_templates pets
667: ,pay_shadow_element_types pset
668: ,pay_template_core_objects ptco
669: ,pay_element_type_extra_info peei
670: WHERE pets.template_id = c_te_usrstr_id -- For the given user structure
671: AND pset.template_id = pets.template_id -- find the base element
672: AND pset.element_name = pets.base_name
673: AND ptco.template_id = pset.template_id -- For the base element