APPS.PAY_EEI_MIG_BUS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 29: , pay_element_type_extra_info eei

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_element_type_extra_info eei
30: , pay_element_types_f pet
31: where eei.element_type_extra_info_id = p_element_type_extra_info_id
32: and pbg.business_group_id = pet.business_group_id
33: and pet.element_type_id = eei.element_type_id;

Line 92: , pay_element_type_extra_info eei

88: --
89: cursor csr_leg_code is
90: select pbg.legislation_code
91: from per_business_groups pbg
92: , pay_element_type_extra_info eei
93: , pay_element_types_f pet
94: where eei.element_type_extra_info_id = p_element_type_extra_info_id
95: and pbg.business_group_id = pet.business_group_id
96: and pet.element_type_id = eei.element_type_id;

Line 859: from pay_element_type_extra_info

855: l_result number;
856:
857: cursor c_duplicate is
858: select 1
859: from pay_element_type_extra_info
860: where element_type_id = p_element_type_id
861: and element_type_extra_info_id <> nvl(p_element_type_extra_info_id, -1)
862: and information_type = 'PQP_UK_RATE_TYPE'
863: and eei_information1 = p_rate_type;

Line 898: from pay_element_type_extra_info

894: l_result number;
895:
896: cursor c_duplicate is
897: select 1
898: from pay_element_type_extra_info
899: where element_type_id <> p_element_type_id
900: and information_type = p_information_type
901: and upper(eei_information2) = upper(p_element_code);
902:

Line 909: from pay_element_type_extra_info

905: p_info_type VARCHAR2
906: )
907: IS
908: select 1
909: from pay_element_type_extra_info
910: where element_type_id = p_element_type_id
911: and information_type = p_info_type;
912: begin
913: --