APPS.PYUDET dependencies on PAY_ELEMENT_ENTRIES_F

Line 1344: from pay_element_entries_f ele

1340:
1341: -- Start of bug#9253974
1342: /*select ele.effective_start_date
1343: into l_future_date
1344: from pay_element_entries_f ele
1345: where ele.effective_start_date >= p_effective_date
1346: and ele.assignment_id = p_assignment_id
1347: and ele.element_type_id = g_element_type_id
1348: order by ele.effective_start_date asc;*/

Line 1354: pay_element_entries_f ele,

1350: -- Modified the cursor to fetch authority code as well.
1351: select ele.effective_start_date,HR_GENERAL.DECODE_LOOKUP('GB_AUTHORITY',eev.screen_entry_value)
1352: into l_future_date, p_auth_code
1353: from
1354: pay_element_entries_f ele,
1355: pay_element_entry_values_f eev,
1356: pay_input_values_f inv
1357: where inv.element_type_id = g_element_type_id
1358: and inv.name = 'Authority'

Line 1941: from pay_element_entries_f ee,

1937: min(decode(inv.name, 'Authority', eev.screen_entry_value, null)) authority_sv ,
1938: min(decode(inv.name, 'Refundable', eev.input_value_id, null)) refundable_id ,
1939: min(decode(inv.name, 'Refundable', eev.screen_entry_value, null)) refundable_sv,
1940: ee.creator_id
1941: from pay_element_entries_f ee,
1942: pay_element_entry_values_f eev,
1943: pay_input_values_f inv
1944: where ee.assignment_id = p_assignment_id
1945: and ee.element_type_id = g_element_type_id

Line 2460: update pay_element_entries_f pef

2456: -- Now stamp the creator id --
2457: ------------------------------
2458: if g_validate_only ='N' then /*Added soy 08-09*/
2459: hr_utility.trace(' In Validate And Commit Mode therefore updating.');
2460: update pay_element_entries_f pef
2461: set pef.creator_id = nvl(g_request_id,g_current_req_id)
2462: where pef.element_entry_id = p_paye_rec.element_entry_id
2463: and pef.effective_start_date = p_per_rec.effective_date;
2464: --and pef.effective_start_date = p_paye_rec.effective_start_date