APPS.PAY_SIMULATOR_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 42: FROM pay_element_entries_f peef

38: INTO v_dummy
39: FROM DUAL
40: WHERE exists (
41: SELECT '1'
42: FROM pay_element_entries_f peef
43: WHERE peef.assignment_id = p_ass_id
44: AND peef.element_type_id =p_ele_typ_id
45: AND p_start_date <= peef.effective_end_date
46: AND p_end_date >= peef.effective_start_date

Line 195: v_new_ee_id pay_element_entries_f.element_entry_id%TYPE;

191: p_inp_val_id_tbl hr_entry.number_table,
192: p_ent_val_tbl hr_entry.varchar2_table
193: ) IS
194: v_ele_link_id pay_element_links_f.element_link_id%TYPE;
195: v_new_ee_id pay_element_entries_f.element_entry_id%TYPE;
196: v_start_date DATE;
197: v_end_date DATE;
198: lv_procedure_name VARCHAR2(100) := '.insert_new_element_entry';
199: emesg VARCHAR2(2000);

Line 296: FROM pay_element_entries_f

292: p_start_date DATE,
293: p_end_date DATE)
294: IS
295: SELECT element_entry_id,effective_start_date,effective_end_date
296: FROM pay_element_entries_f
297: WHERE assignment_id = p_assignment_id
298: AND element_type_id = p_element_type_id
299: AND p_start_date <= effective_end_date
300: AND p_end_date >= effective_start_date

Line 371: FROM pay_element_entries_f

367: p_start_date DATE,
368: p_end_date DATE)
369: IS
370: SELECT element_entry_id,effective_start_date,effective_end_date
371: FROM pay_element_entries_f
372: WHERE assignment_id = p_assignment_id
373: AND p_start_date <= effective_end_date
374: AND p_end_date >= effective_start_date
375: AND CREATOR_TYPE IN ('RR','NR','EE','PR','R','P')

Line 413: FROM pay_element_entries_f peef

409: IS
410: SELECT element_entry_id
411: ,effective_start_date
412: ,effective_end_date
413: FROM pay_element_entries_f peef
414: ,pay_element_set_members pesm
415: WHERE assignment_id = p_assignment_id
416: AND pesm.element_set_id = p_elemset_id
417: AND peef.element_type_id = pesm.element_type_id

Line 458: FROM pay_element_entries_f

454: p_start_date DATE,
455: p_end_date DATE)
456: IS
457: SELECT element_entry_id,effective_start_date,effective_end_date
458: FROM pay_element_entries_f
459: WHERE assignment_id = p_assignment_id
460: AND element_type_id = p_element_type_id
461: AND p_start_date <= effective_end_date
462: AND p_end_date >= effective_start_date

Line 537: FROM pay_element_entries_f

533: p_start_date DATE,
534: p_end_date DATE)
535: IS
536: SELECT element_entry_id,effective_start_date,effective_end_date
537: FROM pay_element_entries_f
538: WHERE assignment_id = p_assignment_id
539: AND element_type_id = p_element_type_id
540: AND p_start_date <= effective_end_date
541: AND p_end_date >= effective_start_date