APPS.PAY_JP_DEF_SS dependencies on PAY_ELEMENT_ENTRIES_F

Line 44: from pay_element_entries_f

40: select 'Y'
41: from dual
42: where exists(
43: select null
44: from pay_element_entries_f
45: where element_entry_id = p_element_entry_id
46: and effective_start_date = p_effective_end_date + 1);
47: begin
48: if p_effective_start_date = p_effective_date then

Line 551: from pay_element_entries_f

547: p_validation_end_date => l_ved);
548: --
549: select object_version_number
550: into p_rec.ee_object_version_number
551: from pay_element_entries_f
552: where element_entry_id = p_rec.element_entry_id
553: and effective_end_date = p_rec.effective_date - 1;
554: --
555: pay_element_entry_api.delete_element_entry(

Line 1403: from pay_element_entries_f

1399: p_validation_end_date => l_ved);
1400: --
1401: select object_version_number
1402: into p_rec.ee_object_version_number
1403: from pay_element_entries_f
1404: where element_entry_id = p_rec.element_entry_id
1405: and effective_end_date = p_rec.effective_date - 1;
1406: --
1407: pay_element_entry_api.delete_element_entry(

Line 1517: pay_element_entries_f pee,

1513: pee.object_version_number,
1514: peev.input_value_id,
1515: peev.screen_entry_value
1516: from pay_element_links_f pel,
1517: pay_element_entries_f pee,
1518: pay_element_entry_values_f peev
1519: where pel.element_type_id = c_def_elm
1520: and pel.business_group_id + 0 = g_business_group_id
1521: and p_effective_date

Line 1541: pay_element_entries_f pee,

1537: pee.effective_end_date,
1538: pee.object_version_number,
1539: peev.screen_entry_value
1540: from pay_link_input_values_f pliv,
1541: pay_element_entries_f pee,
1542: pay_element_entry_values_f peev
1543: where pliv.input_value_id = c_dep_sec_sal_flag_iv
1544: and p_effective_date
1545: between pliv.effective_start_date and pliv.effective_end_date

Line 3026: -- Transfer JP_DEF_ENTRY, JP_DEF_ENTRY_DEP, JP_DEF_ENTRY_OS to PAY_ELEMENT_ENTRIES_F

3022: insert_session(l_assact_rec.effective_date);
3023: end if;
3024: --
3025: --
3026: -- Transfer JP_DEF_ENTRY, JP_DEF_ENTRY_DEP, JP_DEF_ENTRY_OS to PAY_ELEMENT_ENTRIES_F
3027: --
3028: if to_number(to_char(l_assact_rec.effective_date,'YYYY')) >= 2011 then
3029: --
3030: -- assumption, csr_entry_dep (and csr_entry) always return 1 record for assact

Line 3382: -- Rollback Transfer JP_DEF_ENTRY, JP_DEF_ENTRY_DEP, JP_DEF_ENTRY_OS to PAY_ELEMENT_ENTRIES_F

3378: insert_session(l_assact_rec.effective_date);
3379: end if;
3380: --
3381: --
3382: -- Rollback Transfer JP_DEF_ENTRY, JP_DEF_ENTRY_DEP, JP_DEF_ENTRY_OS to PAY_ELEMENT_ENTRIES_F
3383: --
3384: if to_number(to_char(l_assact_rec.effective_date,'YYYY')) >= 2011 then
3385: --
3386: -- assumption, csr_entry_dep (and csr_entry) always return 1 record for assact

Line 3543: from pay_element_entries_f pee

3539: from pay_jp_def_entry_v v
3540: where v.assignment_action_id = p_assignment_action_id
3541: and exists(
3542: select null
3543: from pay_element_entries_f pee
3544: where pee.element_entry_id = v.element_entry_id
3545: and p_expiry_date + 1
3546: between pee.effective_start_date and pee.effective_end_date)
3547: for update nowait;

Line 3556: from pay_element_entries_f pee

3552: from pay_jp_def_entry_os_v v
3553: where v.assignment_action_id = p_assignment_action_id
3554: and exists(
3555: select null
3556: from pay_element_entries_f pee
3557: where pee.element_entry_id = v.element_entry_id
3558: and p_expiry_date + 1
3559: between pee.effective_start_date and pee.effective_end_date)
3560: for update nowait;

Line 3811: from pay_element_entries_f pee

3807: from pay_jp_def_entry_v v
3808: where v.assignment_action_id = p_assignment_action_id
3809: and exists(
3810: select null
3811: from pay_element_entries_f pee
3812: where pee.element_entry_id = v.element_entry_id
3813: and p_expiry_date
3814: between pee.effective_start_date and pee.effective_end_date)
3815: for update nowait;

Line 3826: from pay_element_entries_f pee

3822: from pay_jp_def_entry_os_v v
3823: where v.assignment_action_id = p_assignment_action_id
3824: and exists(
3825: select null
3826: from pay_element_entries_f pee
3827: where pee.element_entry_id = v.element_entry_id
3828: and p_expiry_date
3829: between pee.effective_start_date and pee.effective_end_date)
3830: for update nowait;