APPS.HR_GBNIDIR dependencies on PAY_ELEMENT_ENTRIES_F

Line 1336: ,pay_element_entries_f ENT

1332: -- find the assignments period type
1333: select ENT_PT.screen_entry_value
1334: into l_period_type
1335: from pay_element_entry_values_f ENT_PT
1336: ,pay_element_entries_f ENT
1337: ,pay_element_links_f EL
1338: where ENT_PT.input_value_id + 0 = l_period_type_id
1339: and ENT_PT.element_entry_id = ENT.element_entry_id
1340: and ENT.assignment_id = l_assignment_id

Line 1738: ,pay_element_entries_f ENT

1734: -- find the assignments period type
1735: select max(ENT_PT.screen_entry_value)
1736: into l_value
1737: from pay_element_entry_values_f ENT_PT
1738: ,pay_element_entries_f ENT
1739: ,pay_element_links_f EL
1740: where ENT_PT.input_value_id + 0 = l_input_id
1741: and ENT_PT.element_entry_id = ENT.element_entry_id
1742: and ENT.assignment_id = p_assignment_id

Line 1812: ,pay_element_entries_f ENT

1808: select max(decode(ENT_PT.input_value_id,l_cat_input_id,ENT_PT.screen_entry_value,null)),
1809: max(decode(ENT_PT.input_value_id,l_pen_input_id,ENT_PT.screen_entry_value,null))
1810: into l_category, l_pension
1811: from pay_element_entry_values_f ENT_PT
1812: ,pay_element_entries_f ENT
1813: ,pay_element_links_f EL
1814: where ENT_PT.element_entry_id = ENT.element_entry_id
1815: and ENT.assignment_id = p_assignment_id
1816: and EL.element_type_id = l_element_type_id

Line 2148: ,pay_element_entries_f ENT

2144: c_element_type_id number,
2145: c_effective_date date) is
2146: select ENT_PT.screen_entry_value
2147: from pay_element_entry_values_f ENT_PT
2148: ,pay_element_entries_f ENT
2149: ,pay_element_links_f EL
2150: where ENT_PT.input_value_id + 0 = c_period_type_id
2151: and ENT_PT.element_entry_id = ENT.element_entry_id
2152: and ENT.assignment_id = c_assignment_id