DBA Data[Home] [Help]

APPS.HR_GBNIDIR dependencies on PAY_ELEMENT_ENTRIES_F

Line 1382: ,pay_element_entries_f ENT

1378: ,c_effective_date date)
1379: IS
1380: select ENT_PT.screen_entry_value
1381: from pay_element_entry_values_f ENT_PT
1382: ,pay_element_entries_f ENT
1383: ,pay_element_links_f EL
1384: where ENT_PT.input_value_id + 0 = c_period_type_id
1385: and ENT_PT.element_entry_id = ENT.element_entry_id
1386: and ENT.assignment_id = c_assignment_id

Line 1436: ,pay_element_entries_f ENT

1432: -- find the assignments period type
1433: /* select ENT_PT.screen_entry_value
1434: into l_period_type
1435: from pay_element_entry_values_f ENT_PT
1436: ,pay_element_entries_f ENT
1437: ,pay_element_links_f EL
1438: where ENT_PT.input_value_id + 0 = l_period_type_id
1439: and ENT_PT.element_entry_id = ENT.element_entry_id
1440: and ENT.assignment_id = l_assignment_id

Line 1854: ,pay_element_entries_f ENT

1850: -- find the assignments period type
1851: select max(ENT_PT.screen_entry_value)
1852: into l_value
1853: from pay_element_entry_values_f ENT_PT
1854: ,pay_element_entries_f ENT
1855: ,pay_element_links_f EL
1856: where ENT_PT.input_value_id + 0 = l_input_id
1857: and ENT_PT.element_entry_id = ENT.element_entry_id
1858: and ENT.assignment_id = p_assignment_id

Line 1928: ,pay_element_entries_f ENT

1924: select max(decode(ENT_PT.input_value_id,l_cat_input_id,ENT_PT.screen_entry_value,null)),
1925: max(decode(ENT_PT.input_value_id,l_pen_input_id,ENT_PT.screen_entry_value,null))
1926: into l_category, l_pension
1927: from pay_element_entry_values_f ENT_PT
1928: ,pay_element_entries_f ENT
1929: ,pay_element_links_f EL
1930: where ENT_PT.element_entry_id = ENT.element_entry_id
1931: and ENT.assignment_id = p_assignment_id
1932: and EL.element_type_id = l_element_type_id

Line 2264: ,pay_element_entries_f ENT

2260: c_element_type_id number,
2261: c_effective_date date) is
2262: select ENT_PT.screen_entry_value
2263: from pay_element_entry_values_f ENT_PT
2264: ,pay_element_entries_f ENT
2265: ,pay_element_links_f EL
2266: where ENT_PT.input_value_id + 0 = c_period_type_id
2267: and ENT_PT.element_entry_id = ENT.element_entry_id
2268: and ENT.assignment_id = c_assignment_id