APPS.PER_ASG_AGGR dependencies on PAY_ELEMENT_ENTRIES_F

Line 108: pay_element_entries_f ele,

104: paa.assignment_id assignment_id,
105: eev.effective_start_date effective_start_date,
106: eev.effective_end_date effective_end_date
107: from
108: pay_element_entries_f ele,
109: pay_element_entry_values_f eev,
110: pay_input_values_f inv,
111: pay_element_links_f lnk, pay_element_types_f elt,
112: per_all_assignments_f paa,

Line 181: from pay_element_entries_f ele,

177: -- End of Bug 5671777-9
178:
179: CURSOR cur_paye_element_link IS
180: select count(*)
181: from pay_element_entries_f ele,
182: pay_element_links_f lnk,
183: pay_element_types_f elt,
184: per_all_assignments_f paa
185: where elt.element_name = 'PAYE Details'

Line 1022: FROM pay_element_entries_f ele,

1018: min(decode(inv.name, 'Tax Previous', nvl(eev.screen_entry_value,0), null)) Tax_Previous,
1019: min(decode(inv.name, 'Authority', eev.screen_entry_value, null)) Authority,
1020: min(ele.entry_information1) P6_iss_date,
1021: min(ele.entry_information2) P6_msg_date
1022: FROM pay_element_entries_f ele,
1023: pay_element_entry_values_f eev,
1024: pay_input_values_f inv,
1025: pay_element_links_f lnk,
1026: pay_element_types_f elt,

Line 1076: FROM pay_element_entries_f ele,

1072: min(decode(inv.name, 'Authority', eev.screen_entry_value, null)) Authority,
1073: min(decode(inv.name, 'Authority', eev.input_value_id, null)) Authority_iv_id,
1074: min(ele.entry_information1) P6_iss_date,
1075: min(ele.entry_information2) P6_msg_date
1076: FROM pay_element_entries_f ele,
1077: pay_element_entry_values_f eev,
1078: pay_input_values_f inv,
1079: pay_element_links_f lnk,
1080: pay_element_types_f elt,