APPS.PAY_BALANCE_UPLOAD dependencies on PAY_ELEMENT_ENTRIES_F

Line 2097: from pay_element_entries_f pee,

2093:
2094: CURSOR WCB_input_value(p_inp_name varchar2)
2095: IS
2096: select peev.screen_entry_value
2097: from pay_element_entries_f pee,
2098: pay_element_types_f pet,
2099: pay_element_entry_values_f peev,
2100: pay_input_values_f piv
2101: where pee.assignment_id = p_asg_id

Line 3947: from pay_element_entries_f EE

3943: ,p_assignment_id number
3944: ,p_original_entry_id number
3945: ) is
3946: select EE.element_entry_id
3947: from pay_element_entries_f EE
3948: where EE.assignment_id = p_assignment_id
3949: and EE.entry_type = 'E'
3950: and EE.effective_start_date <= p_upload_date
3951: and EE.element_entry_id = p_original_entry_id

Line 3955: from pay_element_entries_f EE

3951: and EE.element_entry_id = p_original_entry_id
3952: and EE.original_entry_id is null
3953: union all
3954: select EE.element_entry_id
3955: from pay_element_entries_f EE
3956: where EE.assignment_id = p_assignment_id
3957: and EE.entry_type = 'E'
3958: and EE.effective_start_date <= p_upload_date
3959: and EE.original_entry_id = p_original_entry_id;