APPS.HREMPTER dependencies on PAY_ELEMENT_TYPES_F

Line 1032: FROM pay_element_types_f et

1028:
1029: CURSOR chk_element_type_csr(p_element_type_id number,
1030: p_term_rule varchar2 ) IS
1031: SELECT 'Y'
1032: FROM pay_element_types_f et
1033: WHERE et.element_type_id = p_element_type_id
1034: AND et.post_termination_rule = p_term_rule
1035: AND et.processing_type = 'R';
1036: --

Line 1056: pay_element_types_f et

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

Line 1062: pay_element_types_f et

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

Line 1089: , pay_element_types_f pet

1085: , ppp.multiple_components
1086: from per_pay_proposals ppp
1087: , per_all_assignments_f asg
1088: , per_pay_bases ppb
1089: , pay_element_types_f pet
1090: , pay_input_values_f piv
1091: where ppp.assignment_id=p_assignment_id
1092: and asg.assignment_id=p_assignment_id
1093: and ppp.change_date between asg.effective_start_date and asg.effective_end_date

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