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 1673: per_pay_bases PB

1669: and nvl(p_old_date,p_effective_start_date) between
1670: EL.effective_start_date and EL.effective_end_date
1671: and exists (select null
1672: from pay_input_values_f IV,
1673: per_pay_bases PB
1674: where IV.element_type_id = EL.element_type_id
1675: and PB.input_value_id = IV.input_value_id)
1676: UNION ALL
1677: select EL.element_type_id element_type_id,

Line 1689: per_pay_bases PB

1685: and nvl(p_old_date,p_effective_start_date) between
1686: EL.effective_start_date and EL.effective_end_date
1687: and not exists (select null
1688: from pay_input_values_f IV,
1689: per_pay_bases PB
1690: where IV.element_type_id = EL.element_type_id
1691: and PB.input_value_id = IV.input_value_id);
1692: --
1693: -- Local Variables

Line 2196: from per_pay_bases pb,

2192: or
2193: el.pay_basis_id is null and
2194: not exists
2195: (select pb.pay_basis_id
2196: from per_pay_bases pb,
2197: pay_input_values_f iv
2198: where iv.element_type_id = el.element_type_id
2199: and p_validation_start_date between
2200: iv.effective_start_date and iv.effective_end_date

Line 2208: from per_pay_bases pb,

2204: or
2205: el.pay_basis_id is null and
2206: exists
2207: (select pb.pay_basis_id
2208: from per_pay_bases pb,
2209: pay_input_values_f iv
2210: where iv.element_type_id = el.element_type_id
2211: and p_validation_start_date between
2212: iv.effective_start_date and iv.effective_end_date

Line 2221: from per_pay_bases pb,

2217: el.pay_basis_id is null and
2218: p_pay_basis_id is null and
2219: exists
2220: (select pb.pay_basis_id
2221: from per_pay_bases pb,
2222: pay_input_values_f iv
2223: where iv.element_type_id = el.element_type_id
2224: and p_validation_start_date between
2225: iv.effective_start_date and iv.effective_end_date

Line 2690: FROM PER_PAY_BASES pb,

2686: --
2687: el.pay_basis_id is null and
2688: NOT EXISTS
2689: (SELECT pb.pay_basis_id
2690: FROM PER_PAY_BASES pb,
2691: PAY_INPUT_VALUES_F iv,
2692: PER_PAY_PROPOSALS pp
2693: WHERE iv.element_type_id = el.element_type_id
2694: and iv.effective_start_date <= asg.effective_end_date /*Bug 7662923 */

Line 2708: FROM PER_PAY_BASES pb,

2704: --
2705: el.pay_basis_id is null and
2706: EXISTS
2707: (SELECT pb.pay_basis_id
2708: FROM PER_PAY_BASES pb,
2709: PAY_INPUT_VALUES_F iv
2710: WHERE iv.element_type_id = el.element_type_id
2711: and iv.effective_start_date <= asg.effective_start_date
2712: and iv.effective_end_date >= asg.effective_start_date

Line 2724: FROM PER_PAY_BASES pb,

2720: el.pay_basis_id is null and
2721: asg.pay_basis_id is null and
2722: EXISTS
2723: (SELECT pb.pay_basis_id
2724: FROM PER_PAY_BASES pb,
2725: PAY_INPUT_VALUES_F iv
2726: WHERE iv.element_type_id = el.element_type_id
2727: and iv.effective_start_date <= asg.effective_start_date
2728: and iv.effective_end_date >= asg.effective_start_date

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

6440: -- if EL is NOT associated with a pay basis then return true
6441: --
6442: p_pay_basis_id is null and
6443: NOT EXISTS
6444: (SELECT /*+ ORDERED INDEX(pb PER_PAY_BASES_N1)*/
6445: pb.pay_basis_id
6446: FROM PAY_ELEMENT_LINKS_F el,
6447: PAY_INPUT_VALUES_F iv,
6448: PER_PAY_BASES pb

Line 6448: PER_PAY_BASES pb

6444: (SELECT /*+ ORDERED INDEX(pb PER_PAY_BASES_N1)*/
6445: pb.pay_basis_id
6446: FROM PAY_ELEMENT_LINKS_F el,
6447: PAY_INPUT_VALUES_F iv,
6448: PER_PAY_BASES pb
6449: WHERE el.element_link_id = p_element_link_id
6450: and el.effective_start_date <= asg.effective_start_date
6451: and el.effective_end_date >= asg.effective_start_date
6452: and iv.element_type_id =

Line 6469: FROM PER_PAY_BASES pb,

6465: --
6466: p_pay_basis_id is null and
6467: EXISTS
6468: (SELECT pb.pay_basis_id
6469: FROM PER_PAY_BASES pb,
6470: PAY_INPUT_VALUES_F iv,
6471: PAY_ELEMENT_LINKS_F el
6472: WHERE el.element_link_id = p_element_link_id
6473: and el.effective_start_date <= asg.effective_start_date

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

6484: or
6485: p_pay_basis_id is null and
6486: asg.pay_basis_id is null and
6487: EXISTS
6488: (SELECT /*+ ORDERED INDEX(pb PER_PAY_BASES_N1)*/
6489: pb.pay_basis_id
6490: FROM PAY_ELEMENT_LINKS_F el,
6491: PAY_INPUT_VALUES_F iv,
6492: PER_PAY_BASES pb

Line 6492: PER_PAY_BASES pb

6488: (SELECT /*+ ORDERED INDEX(pb PER_PAY_BASES_N1)*/
6489: pb.pay_basis_id
6490: FROM PAY_ELEMENT_LINKS_F el,
6491: PAY_INPUT_VALUES_F iv,
6492: PER_PAY_BASES pb
6493: WHERE el.element_link_id = p_element_link_id
6494: and el.effective_start_date <= asg.effective_start_date
6495: and el.effective_end_date >= asg.effective_start_date
6496: and iv.element_type_id =

Line 7019: from per_pay_bases pb,

7015: (asg.pay_basis_id is null
7016: -- Indirect salary basis check.
7017: or not exists
7018: (select pb.pay_basis_id
7019: from per_pay_bases pb,
7020: pay_input_values_f iv
7021: where iv.element_type_id = p_element_type_id
7022: and pb.input_value_id = iv.input_value_id
7023: and pb.business_group_id = p_business_group_id

Line 7027: from per_pay_bases pb,

7023: and pb.business_group_id = p_business_group_id
7024: )
7025: or exists
7026: (select pb.pay_basis_id
7027: from per_pay_bases pb,
7028: pay_input_values_f iv
7029: where iv.element_type_id = p_element_type_id
7030: and pb.input_value_id = iv.input_value_id
7031: and pb.pay_basis_id = asg.pay_basis_id

Line 7088: from per_pay_bases pb,

7084: (asg.pay_basis_id is null
7085: -- Indirect salary basis check.
7086: or not exists
7087: (select pb.pay_basis_id
7088: from per_pay_bases pb,
7089: pay_input_values_f iv
7090: where iv.element_type_id = p_element_type_id
7091: and pb.input_value_id = iv.input_value_id
7092: and pb.business_group_id = p_business_group_id

Line 7096: from per_pay_bases pb,

7092: and pb.business_group_id = p_business_group_id
7093: )
7094: or exists
7095: (select pb.pay_basis_id
7096: from per_pay_bases pb,
7097: pay_input_values_f iv
7098: where iv.element_type_id = p_element_type_id
7099: and pb.input_value_id = iv.input_value_id
7100: and pb.pay_basis_id = asg.pay_basis_id