APPS.HREMPTER dependencies on PAY_ELEMENT_LINKS_F

Line 1055: FROM pay_element_links_f el,

1051: AND ee.effective_end_date > p_term_date
1052: AND ((ee.entry_type <> 'E')
1053: OR (ee.entry_type = 'E'
1054: AND EXISTS (SELECT NULL
1055: FROM pay_element_links_f el,
1056: pay_element_types_f et
1057: WHERE el.element_link_id = ee.element_link_id
1058: AND et.element_type_id = el.element_type_id
1059: AND et.processing_type = 'N')))

Line 1061: FROM pay_element_links_f el,

1057: WHERE el.element_link_id = ee.element_link_id
1058: AND et.element_type_id = el.element_type_id
1059: AND et.processing_type = 'N')))
1060: AND EXISTS (SELECT NULL
1061: FROM pay_element_links_f el,
1062: pay_element_types_f et
1063: WHERE el.element_link_id = ee.element_link_id
1064: AND et.element_type_id = el.element_type_id
1065: AND et.post_termination_rule = p_term_rule)

Line 1149: FROM pay_element_links_f el

1145: l_type_exists := 'N';
1146:
1147: SELECT el.element_type_id
1148: INTO l_element_type_id
1149: FROM pay_element_links_f el
1150: WHERE el.element_link_id = rec_entry.element_link_id
1151: AND rec_entry.effective_end_date BETWEEN el.effective_start_date
1152: AND el.effective_end_date;
1153: hr_entry.chk_element_entry_open(l_element_type_id,

Line 1242: FROM pay_element_links_f el, pay_element_types_f et

1238: p_term_rule) LOOP
1239: l_process_in_run_flag := 'N';
1240: SELECT el.element_type_id, et.process_in_run_flag
1241: INTO l_element_type_id, l_process_in_run_flag
1242: FROM pay_element_links_f el, pay_element_types_f et
1243: WHERE el.element_link_id = nonrec_entry.element_link_id
1244: AND et.element_type_id = el.element_type_id
1245: AND nonrec_entry.effective_end_date BETWEEN el.effective_start_date
1246: AND el.effective_end_date

Line 1397: FROM pay_element_links_f el

1393: -- are open periods
1394:
1395: SELECT el.element_type_id
1396: INTO l_element_type_id
1397: FROM pay_element_links_f el
1398: WHERE el.element_link_id = rec_entry.element_link_id
1399: AND rec_entry.effective_end_date BETWEEN el.effective_start_date
1400: AND el.effective_end_date;
1401: --

Line 1541: FROM pay_element_links_f el, pay_element_types_f et

1537: -- are open periods
1538: -- VT 03/01/96 changed to fix bug #334654,#334681
1539: SELECT el.element_type_id, et.process_in_run_flag
1540: INTO l_element_type_id, l_process_in_run_flag
1541: FROM pay_element_links_f el, pay_element_types_f et
1542: WHERE el.element_link_id = nonrec_entry.element_link_id
1543: AND et.element_type_id = el.element_type_id
1544: AND nonrec_entry.effective_end_date BETWEEN el.effective_start_date
1545: AND el.effective_end_date