APPS.PAY_US_RULES dependencies on PAY_ELEMENT_ENTRIES_F

Line 194: pay_element_entries_f pee

190: cursor csr_ele_classification is
191: select classification_name
192: from pay_element_classifications pec,
193: pay_element_types_f pet,
194: pay_element_entries_f pee
195: where pec.classification_id = pet.classification_id
196: and pet.element_type_id = pee.element_type_id
197: and pee.element_entry_id = p_ee_id;
198:

Line 2095: pay_element_entries_f pee

2091: ,cp_date DATE
2092: ) IS
2093: SELECT element_name
2094: FROM pay_element_types_f pet,
2095: pay_element_entries_f pee
2096: WHERE pee.element_entry_id = cp_element_entry
2097: AND pee.element_type_id = pet.element_type_id
2098: AND ((pet.legislation_code = 'US' and pet.business_group_id is null)
2099: or (pet.legislation_code is null and pet.business_group_id = cp_bus_grp))

Line 2249: pay_element_entries_f peef,

2245: ) IS
2246: SELECT peev.screen_entry_value
2247: FROM pay_element_types_f pet,
2248: pay_input_values_f piv,
2249: pay_element_entries_f peef,
2250: pay_element_entry_values_f peev
2251: WHERE pet.element_name = cp_ele_name
2252: AND pet.business_group_id is NULL
2253: AND peef.element_type_id = pet.element_type_id

Line 2314: pay_element_entries_f pee

2310: ,cp_date DATE
2311: ) IS
2312: SELECT element_name
2313: FROM pay_element_types_f pet,
2314: pay_element_entries_f pee
2315: WHERE pee.element_entry_id = cp_element_entry
2316: AND pee.element_type_id = pet.element_type_id
2317: AND ((pet.legislation_code = 'US' and pet.business_group_id is null)
2318: or (pet.legislation_code is null and pet.business_group_id = cp_bus_grp))