APPS.HR_GBNIDIR dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1335: from pay_element_entry_values_f ENT_PT

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

Line 1737: from pay_element_entry_values_f ENT_PT

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

Line 1811: from pay_element_entry_values_f ENT_PT

1807: -- (Performance fix).
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

Line 2147: from pay_element_entry_values_f ENT_PT

2143: c_assignment_id number,
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