APPS.PAY_EEI_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 989: from pay_element_type_extra_info

985: l_result number;
986:
987: cursor c_duplicate is
988: select 1
989: from pay_element_type_extra_info
990: where element_type_id = p_element_type_id
991: and element_type_extra_info_id <> nvl(p_element_type_extra_info_id, -1)
992: and information_type = 'PQP_UK_RATE_TYPE'
993: and eei_information1 = p_rate_type;

Line 1030: from pay_element_type_extra_info

1026: l_is_advanced_retro_enabled number;
1027: /*
1028: cursor c_duplicate is
1029: select 1
1030: from pay_element_type_extra_info
1031: where element_type_id <> p_element_type_id
1032: and information_type = p_information_type
1033: and upper(eei_information2) = upper(p_element_code);
1034: */

Line 1046: from pay_element_type_extra_info petei,pay_element_types_f pet

1042:
1043:
1044: cursor c_duplicate is
1045: select 1
1046: from pay_element_type_extra_info petei,pay_element_types_f pet
1047: where petei.element_type_id <> p_element_type_id
1048: and information_type = p_information_type
1049: and upper(eei_information2) = upper(p_element_code)
1050: and petei.element_type_id not in ((select element_type_id

Line 1064: from pay_element_type_extra_info petei,pay_element_types_f pet

1060:
1061:
1062: cursor c_duplicate_advanced_retro is
1063: select 1
1064: from pay_element_type_extra_info petei,pay_element_types_f pet
1065: where petei.element_type_id <> p_element_type_id
1066: and information_type = p_information_type
1067: and upper(eei_information2) = upper(p_element_code)
1068: and petei.element_type_id not in ((select prcu.creator_id

Line 1096: from pay_element_type_extra_info

1092: p_info_type VARCHAR2
1093: )
1094: IS
1095: select 1
1096: from pay_element_type_extra_info
1097: where element_type_id = p_element_type_id
1098: and information_type = p_info_type;
1099: begin
1100: --