APPS.PAY_JP_DEF_SS dependencies on PAY_ELEMENT_ENTRIES_F

Line 37: from pay_element_entries_f

33: select 'Y'
34: from dual
35: where exists(
36: select null
37: from pay_element_entries_f
38: where element_entry_id = p_element_entry_id
39: and effective_start_date = p_effective_end_date + 1);
40: begin
41: if p_effective_start_date = p_effective_date then

Line 531: from pay_element_entries_f

527: p_validation_end_date => l_ved);
528: --
529: select object_version_number
530: into p_rec.ee_object_version_number
531: from pay_element_entries_f
532: where element_entry_id = p_rec.element_entry_id
533: and effective_end_date = p_rec.effective_date - 1;
534: --
535: pay_element_entry_api.delete_element_entry(

Line 1337: pay_element_entries_f pee,

1333: pee.object_version_number,
1334: peev.input_value_id,
1335: peev.screen_entry_value
1336: from pay_element_entry_values_f peev,
1337: pay_element_entries_f pee,
1338: pay_element_links_f pel
1339: where pel.element_type_id = c_def_elm
1340: and pel.business_group_id + 0 = p_business_group_id
1341: and p_effective_date

Line 2359: -- Transfer JP_DEF_ENTRY to PAY_ELEMENT_ENTRIES_F

2355: if p_create_session then
2356: insert_session(l_assact_rec.effective_date);
2357: end if;
2358: --
2359: -- Transfer JP_DEF_ENTRY to PAY_ELEMENT_ENTRIES_F
2360: --
2361: for l_rec in csr_entry(l_assact_rec.assignment_action_id) loop
2362: transfer_entry(l_rec);
2363: end loop;

Line 2629: -- Rollback Transfer JP_DEF_ENTRY to PAY_ELEMENT_ENTRIES_F

2625: if p_create_session then
2626: insert_session(l_assact_rec.effective_date);
2627: end if;
2628: --
2629: -- Rollback Transfer JP_DEF_ENTRY to PAY_ELEMENT_ENTRIES_F
2630: --
2631: for l_rec in csr_entry(l_assact_rec.assignment_action_id) loop
2632: rollback_entry(l_rec);
2633: end loop;

Line 2747: from pay_element_entries_f pee

2743: from pay_jp_def_entry_v v
2744: where v.assignment_action_id = p_assignment_action_id
2745: and exists(
2746: select null
2747: from pay_element_entries_f pee
2748: where pee.element_entry_id = v.element_entry_id
2749: and p_expiry_date + 1
2750: between pee.effective_start_date and pee.effective_end_date)
2751: for update nowait;

Line 2951: from pay_element_entries_f pee

2947: from pay_jp_def_entry_v v
2948: where v.assignment_action_id = p_assignment_action_id
2949: and exists(
2950: select null
2951: from pay_element_entries_f pee
2952: where pee.element_entry_id = v.element_entry_id
2953: and p_expiry_date
2954: between pee.effective_start_date and pee.effective_end_date)
2955: for update nowait;