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 PER_PAY_BASES

Line 1460: per_pay_bases PB

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
1464: select EL.element_type_id element_type_id,

Line 1476: per_pay_bases PB

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: --
1480: -- Local Variables

Line 1916: from per_pay_bases pb,

1912: or
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

Line 1928: from per_pay_bases pb,

1924: or
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

Line 1941: from per_pay_bases pb,

1937: el.pay_basis_id is null and
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

Line 2359: FROM PER_PAY_BASES pb,

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

Line 2377: FROM PER_PAY_BASES pb,

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

Line 2393: FROM PER_PAY_BASES pb,

2389: el.pay_basis_id is null and
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

Line 5589: (SELECT /+ ORDERED INDEX(pb PER_PAY_BASES_N1)/

5585: -- if EL is NOT associated with a pay basis then return true
5586: --
5587: p_pay_basis_id is null and
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

Line 5593: PER_PAY_BASES pb

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
5597: and iv.element_type_id =

Line 5614: FROM PER_PAY_BASES pb,

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

Line 5633: (SELECT /+ ORDERED INDEX(pb PER_PAY_BASES_N1)/

5629: or
5630: p_pay_basis_id is null and
5631: asg.pay_basis_id is null and
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

Line 5637: PER_PAY_BASES pb

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
5641: and iv.element_type_id =

Line 6085: from per_pay_bases pb,

6081: (asg.pay_basis_id is null
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

Line 6093: from per_pay_bases pb,

6089: and pb.business_group_id = p_business_group_id
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