eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRENTMNT dependencies on PAY_INPUT_VALUES_F

Line 1130: pay_input_values_f iv,

1126: -- Bugfix 2827092
1127: iv.value_set_id,
1128: et.input_currency_code
1129: from pay_element_entry_values_f eev,
1130: pay_input_values_f iv,
1131: pay_element_types_f et
1132: where eev.element_entry_id = p_element_entry_id
1133: and iv.input_value_id = eev.input_value_id
1134: and et.element_type_id = iv.element_type_id

Line 1459: from pay_input_values_f IV,

1455: EE.effective_start_date and EE.effective_end_date
1456: and nvl(p_old_date,p_effective_start_date) between
1457: EL.effective_start_date and EL.effective_end_date
1458: and exists (select null
1459: from pay_input_values_f IV,
1460: per_pay_bases PB
1461: where IV.element_type_id = EL.element_type_id
1462: and PB.input_value_id = IV.input_value_id)
1463: UNION ALL

Line 1475: from pay_input_values_f IV,

1471: EE.effective_start_date and EE.effective_end_date
1472: and nvl(p_old_date,p_effective_start_date) between
1473: EL.effective_start_date and EL.effective_end_date
1474: and not exists (select null
1475: from pay_input_values_f IV,
1476: per_pay_bases PB
1477: where IV.element_type_id = EL.element_type_id
1478: and PB.input_value_id = IV.input_value_id);
1479: --

Line 1917: pay_input_values_f iv

1913: el.pay_basis_id is null and
1914: not exists
1915: (select pb.pay_basis_id
1916: from per_pay_bases pb,
1917: pay_input_values_f iv
1918: where iv.element_type_id = el.element_type_id
1919: and p_validation_start_date between
1920: iv.effective_start_date and iv.effective_end_date
1921: and pb.input_value_id = iv.input_value_id

Line 1929: pay_input_values_f iv

1925: el.pay_basis_id is null and
1926: exists
1927: (select pb.pay_basis_id
1928: from per_pay_bases pb,
1929: pay_input_values_f iv
1930: where iv.element_type_id = el.element_type_id
1931: and p_validation_start_date between
1932: iv.effective_start_date and iv.effective_end_date
1933: and pb.input_value_id = iv.input_value_id

Line 1942: pay_input_values_f iv

1938: p_pay_basis_id is null and
1939: exists
1940: (select pb.pay_basis_id
1941: from per_pay_bases pb,
1942: pay_input_values_f iv
1943: where iv.element_type_id = el.element_type_id
1944: and p_validation_start_date between
1945: iv.effective_start_date and iv.effective_end_date
1946: and pb.input_value_id = iv.input_value_id

Line 2360: PAY_INPUT_VALUES_F iv,

2356: el.pay_basis_id is null and
2357: NOT EXISTS
2358: (SELECT pb.pay_basis_id
2359: FROM PER_PAY_BASES pb,
2360: PAY_INPUT_VALUES_F iv,
2361: PER_PAY_PROPOSALS pp
2362: WHERE iv.element_type_id = el.element_type_id
2363: and iv.effective_start_date <= asg.effective_start_date
2364: and iv.effective_end_date >= asg.effective_start_date

Line 2378: PAY_INPUT_VALUES_F iv

2374: el.pay_basis_id is null and
2375: EXISTS
2376: (SELECT pb.pay_basis_id
2377: FROM PER_PAY_BASES pb,
2378: PAY_INPUT_VALUES_F iv
2379: WHERE iv.element_type_id = el.element_type_id
2380: and iv.effective_start_date <= asg.effective_start_date
2381: and iv.effective_end_date >= asg.effective_start_date
2382: and pb.input_value_id =

Line 2394: PAY_INPUT_VALUES_F iv

2390: asg.pay_basis_id is null and
2391: EXISTS
2392: (SELECT pb.pay_basis_id
2393: FROM PER_PAY_BASES pb,
2394: PAY_INPUT_VALUES_F iv
2395: WHERE iv.element_type_id = el.element_type_id
2396: and iv.effective_start_date <= asg.effective_start_date
2397: and iv.effective_end_date >= asg.effective_start_date
2398: and pb.input_value_id =

Line 5592: PAY_INPUT_VALUES_F iv,

5588: NOT EXISTS
5589: (SELECT /*+ ORDERED INDEX(pb PER_PAY_BASES_N1)*/
5590: pb.pay_basis_id
5591: FROM PAY_ELEMENT_LINKS_F el,
5592: PAY_INPUT_VALUES_F iv,
5593: PER_PAY_BASES pb
5594: WHERE el.element_link_id = p_element_link_id
5595: and el.effective_start_date <= asg.effective_start_date
5596: and el.effective_end_date >= asg.effective_start_date

Line 5615: PAY_INPUT_VALUES_F iv,

5611: p_pay_basis_id is null and
5612: EXISTS
5613: (SELECT pb.pay_basis_id
5614: FROM PER_PAY_BASES pb,
5615: PAY_INPUT_VALUES_F iv,
5616: PAY_ELEMENT_LINKS_F el
5617: WHERE el.element_link_id = p_element_link_id
5618: and el.effective_start_date <= asg.effective_start_date
5619: and el.effective_end_date >= asg.effective_start_date

Line 5636: PAY_INPUT_VALUES_F iv,

5632: EXISTS
5633: (SELECT /*+ ORDERED INDEX(pb PER_PAY_BASES_N1)*/
5634: pb.pay_basis_id
5635: FROM PAY_ELEMENT_LINKS_F el,
5636: PAY_INPUT_VALUES_F iv,
5637: PER_PAY_BASES pb
5638: WHERE el.element_link_id = p_element_link_id
5639: and el.effective_start_date <= asg.effective_start_date
5640: and el.effective_end_date >= asg.effective_start_date

Line 6086: pay_input_values_f iv

6082: -- Indirect salary basis check.
6083: or not exists
6084: (select pb.pay_basis_id
6085: from per_pay_bases pb,
6086: pay_input_values_f iv
6087: where iv.element_type_id = p_element_type_id
6088: and pb.input_value_id = iv.input_value_id
6089: and pb.business_group_id = p_business_group_id
6090: )

Line 6094: pay_input_values_f iv

6090: )
6091: or exists
6092: (select pb.pay_basis_id
6093: from per_pay_bases pb,
6094: pay_input_values_f iv
6095: where iv.element_type_id = p_element_type_id
6096: and pb.input_value_id = iv.input_value_id
6097: and pb.pay_basis_id = asg.pay_basis_id
6098: )