APPS.HREMPTER dependencies on PAY_ELEMENT_TYPES_F

Line 1050: FROM pay_element_types_f et

1046:
1047: CURSOR chk_element_type_csr(p_element_type_id number,
1048: p_term_rule varchar2 ) IS
1049: SELECT 'Y'
1050: FROM pay_element_types_f et
1051: WHERE et.element_type_id = p_element_type_id
1052: AND et.post_termination_rule = p_term_rule
1053: AND et.processing_type = 'R';
1054: --

Line 1074: pay_element_types_f et

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')))
1078: AND EXISTS (SELECT NULL

Line 1080: pay_element_types_f et

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)
1084: GROUP BY ee.element_entry_id, ee.element_link_id;

Line 1107: , pay_element_types_f pet

1103: , ppp.multiple_components
1104: from per_pay_proposals ppp
1105: , per_all_assignments_f asg
1106: , per_pay_bases ppb
1107: , pay_element_types_f pet
1108: , pay_input_values_f piv
1109: where ppp.assignment_id=p_assignment_id
1110: and asg.assignment_id=p_assignment_id
1111: and ppp.change_date between asg.effective_start_date and asg.effective_end_date

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 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