DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PAY_ELEMENT_ENTRIES_F

Line 249: pay_element_entries_f pee

245: cursor csr_ele_classification is
246: select classification_name
247: from pay_element_classifications pec,
248: pay_element_types_f pet,
249: pay_element_entries_f pee
250: where pec.classification_id = pet.classification_id
251: and pet.element_type_id = pee.element_type_id
252: and pee.element_entry_id = p_ee_id;
253:

Line 2155: pay_element_entries_f pee

2151: ,cp_date DATE
2152: ) IS
2153: SELECT element_name
2154: FROM pay_element_types_f pet,
2155: pay_element_entries_f pee
2156: WHERE pee.element_entry_id = cp_element_entry
2157: AND pee.element_type_id = pet.element_type_id
2158: AND ((pet.legislation_code = 'US' and pet.business_group_id is null)
2159: or (pet.legislation_code is null and pet.business_group_id = cp_bus_grp))

Line 2309: pay_element_entries_f peef,

2305: ) IS
2306: SELECT peev.screen_entry_value
2307: FROM pay_element_types_f pet,
2308: pay_input_values_f piv,
2309: pay_element_entries_f peef,
2310: pay_element_entry_values_f peev
2311: WHERE pet.element_name = cp_ele_name
2312: AND pet.business_group_id is NULL
2313: AND peef.element_type_id = pet.element_type_id

Line 2374: pay_element_entries_f pee

2370: ,cp_date DATE
2371: ) IS
2372: SELECT element_name
2373: FROM pay_element_types_f pet,
2374: pay_element_entries_f pee
2375: WHERE pee.element_entry_id = cp_element_entry
2376: AND pee.element_type_id = pet.element_type_id
2377: AND ((pet.legislation_code = 'US' and pet.business_group_id is null)
2378: or (pet.legislation_code is null and pet.business_group_id = cp_bus_grp))