APPS.PYUDET dependencies on PAY_ELEMENT_ENTRIES_F

Line 1215: from pay_element_entries_f ele

1211: BEGIN
1212: hr_utility.trace(' Check future change');
1213: select ele.effective_start_date
1214: into l_future_date
1215: from pay_element_entries_f ele
1216: where ele.effective_start_date >= p_effective_date
1217: and ele.assignment_id = p_assignment_id
1218: and ele.element_type_id = g_element_type_id
1219: order by ele.effective_start_date asc;

Line 1737: from pay_element_entries_f ee,

1733: min(decode(inv.name, 'Authority', eev.screen_entry_value, null)) authority_sv ,
1734: min(decode(inv.name, 'Refundable', eev.input_value_id, null)) refundable_id ,
1735: min(decode(inv.name, 'Refundable', eev.screen_entry_value, null)) refundable_sv,
1736: ee.creator_id
1737: from pay_element_entries_f ee,
1738: pay_element_entry_values_f eev,
1739: pay_input_values_f inv
1740: where ee.assignment_id = p_assignment_id
1741: and ee.element_type_id = g_element_type_id

Line 2076: update pay_element_entries_f pef

2072: -- Now stamp the creator id --
2073: ------------------------------
2074: if g_validate_only ='N' then /*Added soy 08-09*/
2075: hr_utility.trace(' In Validate And Commit Mode therefore updating.');
2076: update pay_element_entries_f pef
2077: set pef.creator_id = nvl(g_request_id,g_current_req_id)
2078: where pef.element_entry_id = p_paye_rec.element_entry_id
2079: and pef.effective_start_date = p_per_rec.effective_date;
2080: --and pef.effective_start_date = p_paye_rec.effective_start_date