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.

[Home] [Help]

APPS.HRENTMNT dependencies on PAY_INPUT_VALUES_F

Line 990: pay_input_values_f iv,

986: -- Bugfix 2827092
987: iv.value_set_id,
988: et.input_currency_code
989: from pay_element_entry_values_f eev,
990: pay_input_values_f iv,
991: pay_element_types_f et
992: where eev.element_entry_id = p_element_entry_id
993: and iv.input_value_id = eev.input_value_id
994: and et.element_type_id = iv.element_type_id

Line 1672: from pay_input_values_f IV,

1668: EE.effective_start_date and EE.effective_end_date
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

Line 1688: from pay_input_values_f IV,

1684: EE.effective_start_date and EE.effective_end_date
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: --

Line 2197: pay_input_values_f iv

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
2201: and pb.input_value_id = iv.input_value_id

Line 2209: pay_input_values_f iv

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
2213: and pb.input_value_id = iv.input_value_id

Line 2222: pay_input_values_f iv

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
2226: and pb.input_value_id = iv.input_value_id

Line 2691: PAY_INPUT_VALUES_F iv,

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 */
2695: and iv.effective_end_date >= asg.effective_start_date

Line 2709: PAY_INPUT_VALUES_F iv

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
2713: and pb.input_value_id =

Line 2725: PAY_INPUT_VALUES_F iv

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
2729: and pb.input_value_id =

Line 6447: PAY_INPUT_VALUES_F iv,

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

Line 6470: PAY_INPUT_VALUES_F iv,

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
6474: and el.effective_end_date >= asg.effective_start_date

Line 6491: PAY_INPUT_VALUES_F iv,

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

Line 7020: pay_input_values_f iv

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
7024: )

Line 7028: pay_input_values_f iv

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
7032: )

Line 7089: pay_input_values_f iv

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
7093: )

Line 7097: pay_input_values_f iv

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
7101: )