APPS.HREMPTER dependencies on PAY_ELEMENT_LINKS_F

Line 1073: FROM pay_element_links_f el,

1069: AND ee.effective_end_date > p_term_date
1070: AND ((ee.entry_type <> 'E')
1071: OR (ee.entry_type = 'E'
1072: AND EXISTS (SELECT NULL
1073: FROM pay_element_links_f el,
1074: pay_element_types_f et
1075: WHERE el.element_link_id = ee.element_link_id
1076: AND et.element_type_id = el.element_type_id
1077: AND et.processing_type = 'N')))

Line 1079: FROM pay_element_links_f el,

1075: WHERE el.element_link_id = ee.element_link_id
1076: AND et.element_type_id = el.element_type_id
1077: AND et.processing_type = 'N')))
1078: AND EXISTS (SELECT NULL
1079: FROM pay_element_links_f el,
1080: pay_element_types_f et
1081: WHERE el.element_link_id = ee.element_link_id
1082: AND et.element_type_id = el.element_type_id
1083: AND et.post_termination_rule = p_term_rule)

Line 1167: FROM pay_element_links_f el

1163: l_type_exists := 'N';
1164:
1165: SELECT el.element_type_id
1166: INTO l_element_type_id
1167: FROM pay_element_links_f el
1168: WHERE el.element_link_id = rec_entry.element_link_id
1169: AND rec_entry.effective_end_date BETWEEN el.effective_start_date
1170: AND el.effective_end_date;
1171: hr_entry.chk_element_entry_open(l_element_type_id,

Line 1260: FROM pay_element_links_f el, pay_element_types_f et

1256: p_term_rule) LOOP
1257: l_process_in_run_flag := 'N';
1258: SELECT el.element_type_id, et.process_in_run_flag
1259: INTO l_element_type_id, l_process_in_run_flag
1260: FROM pay_element_links_f el, pay_element_types_f et
1261: WHERE el.element_link_id = nonrec_entry.element_link_id
1262: AND et.element_type_id = el.element_type_id
1263: AND nonrec_entry.effective_end_date BETWEEN el.effective_start_date
1264: AND el.effective_end_date

Line 1415: FROM pay_element_links_f el

1411: -- are open periods
1412:
1413: SELECT el.element_type_id
1414: INTO l_element_type_id
1415: FROM pay_element_links_f el
1416: WHERE el.element_link_id = rec_entry.element_link_id
1417: AND rec_entry.effective_end_date BETWEEN el.effective_start_date
1418: AND el.effective_end_date;
1419: --

Line 1559: FROM pay_element_links_f el, pay_element_types_f et

1555: -- are open periods
1556: -- VT 03/01/96 changed to fix bug #334654,#334681
1557: SELECT el.element_type_id, et.process_in_run_flag
1558: INTO l_element_type_id, l_process_in_run_flag
1559: FROM pay_element_links_f el, pay_element_types_f et
1560: WHERE el.element_link_id = nonrec_entry.element_link_id
1561: AND et.element_type_id = el.element_type_id
1562: AND nonrec_entry.effective_end_date BETWEEN el.effective_start_date
1563: AND el.effective_end_date