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.PAY_NL_PAYSLIP_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 391: FROM pay_input_values_f piv

387:
388: CURSOR csr_input_value_uom(p_input_value_id NUMBER,
389: p_effective_date DATE) IS
390: SELECT piv.uom
391: FROM pay_input_values_f piv
392: WHERE piv.input_value_id = p_input_value_id
393: AND p_effective_date BETWEEN piv.effective_start_date
394: AND piv.effective_end_date;
395:

Line 1583: ,pay_input_values_f piv

1579: SELECT prv.result_value value
1580: ,prv1.result_value si_type
1581: FROM pay_run_result_values prv
1582: ,pay_run_results prr
1583: ,pay_input_values_f piv
1584: ,pay_input_values_f piv1
1585: ,pay_run_result_values prv1
1586: ,pay_element_types_f pet
1587: WHERE prr.status IN ('P','PA')

Line 1584: ,pay_input_values_f piv1

1580: ,prv1.result_value si_type
1581: FROM pay_run_result_values prv
1582: ,pay_run_results prr
1583: ,pay_input_values_f piv
1584: ,pay_input_values_f piv1
1585: ,pay_run_result_values prv1
1586: ,pay_element_types_f pet
1587: WHERE prr.status IN ('P','PA')
1588: AND prv.run_result_id = prr.run_result_id

Line 1627: ,pay_input_values_f piv

1623: select result_value
1624: from pay_run_result_values prrv
1625: , pay_run_results prr
1626: ,pay_element_types_f pet
1627: ,pay_input_values_f piv
1628: where prrv.run_result_id=prr.run_result_id
1629: and prr.assignment_action_id=p_asg_act_id
1630: and prr.element_type_id=pet.element_type_id
1631: and pet.element_name = 'Special Tax Deduction'

Line 2128: FROM pay_input_values_f piv

2124: --
2125: CURSOR check_si_type (p_element_type_id NUMBER
2126: ,p_effective_date DATE) IS
2127: SELECT 1
2128: FROM pay_input_values_f piv
2129: WHERE piv.element_type_id = p_element_type_id
2130: AND piv.NAME = 'SI Type'
2131: AND p_effective_date BETWEEN piv.effective_start_date
2132: AND piv.effective_end_date;

Line 2158: ,pay_input_values_f piv

2154: SELECT prv.result_value value
2155: ,prv1.result_value si_type
2156: FROM pay_run_result_values prv
2157: ,pay_run_results prr
2158: ,pay_input_values_f piv
2159: ,pay_run_result_values prv1
2160: WHERE prr.status IN ('P','PA')
2161: AND prv.run_result_id = prr.run_result_id
2162: AND prr.assignment_action_id = p_assignment_action_id

Line 2178: from pay_input_values_f piv

2174: --
2175: CURSOR csr_get_si_type_name_iv_id(p_element_type_id NUMBER
2176: ,p_effective_date DATE) IS
2177: select piv.input_value_id
2178: from pay_input_values_f piv
2179: ,pay_element_types_f pet
2180: where
2181: pet.element_type_id=p_element_type_id
2182: and pet.element_type_id=piv.element_type_id

Line 2195: ,pay_input_values_f piv

2191: Select prv1.result_value si_type_name
2192: From
2193: pay_run_result_values prv
2194: ,pay_run_results prr
2195: ,pay_input_values_f piv
2196: ,pay_run_result_values prv1
2197: ,pay_input_values_f piv1
2198: where prr.status in ('P','PA')
2199: AND prr.run_result_id = prv.run_result_id

Line 2197: ,pay_input_values_f piv1

2193: pay_run_result_values prv
2194: ,pay_run_results prr
2195: ,pay_input_values_f piv
2196: ,pay_run_result_values prv1
2197: ,pay_input_values_f piv1
2198: where prr.status in ('P','PA')
2199: AND prr.run_result_id = prv.run_result_id
2200: AND prr.assignment_action_id = p_assignment_action_id
2201: AND prr.element_type_id = p_element_type_id

Line 2437: ,pay_input_values_f piv

2433: ,p_si_type VARCHAR2) IS
2434: SELECT prrv1.result_value si_type_name
2435: FROM pay_balance_feeds_f pbf
2436: ,pay_balance_types pbt
2437: ,pay_input_values_f piv
2438: ,pay_input_values_f piv1
2439: ,pay_input_values_f piv2
2440: ,pay_element_types_f pet
2441: ,pay_run_results prr

Line 2438: ,pay_input_values_f piv1

2434: SELECT prrv1.result_value si_type_name
2435: FROM pay_balance_feeds_f pbf
2436: ,pay_balance_types pbt
2437: ,pay_input_values_f piv
2438: ,pay_input_values_f piv1
2439: ,pay_input_values_f piv2
2440: ,pay_element_types_f pet
2441: ,pay_run_results prr
2442: ,pay_run_result_values prrv

Line 2439: ,pay_input_values_f piv2

2435: FROM pay_balance_feeds_f pbf
2436: ,pay_balance_types pbt
2437: ,pay_input_values_f piv
2438: ,pay_input_values_f piv1
2439: ,pay_input_values_f piv2
2440: ,pay_element_types_f pet
2441: ,pay_run_results prr
2442: ,pay_run_result_values prrv
2443: ,pay_run_result_values prrv1

Line 2746: ,pay_input_values_f piv

2742: FROM pay_run_result_values prv
2743: ,pay_run_results prr
2744: ,pay_element_types_f pet
2745: ,pay_element_types_f_tl pettl
2746: ,pay_input_values_f piv
2747: ,pay_element_classifications pec
2748: ,pay_element_entries_f pee
2749: WHERE prr.status IN ('P','PA')
2750: AND prr.source_id = pee.element_entry_id

Line 2779: ,pay_input_values_f piv

2775: FROM pay_run_result_values prv
2776: ,pay_run_results prr
2777: ,pay_element_types_f pet
2778: ,pay_element_types_f_tl pettl
2779: ,pay_input_values_f piv
2780: ,pay_element_classifications pec
2781: WHERE prr.status IN ('P','PA')
2782: AND prv.run_result_id = prr.run_result_id
2783: AND prr.assignment_action_id = p_run_assign_action_id

Line 2817: ,pay_input_values_f piv

2813: FROM pay_run_result_values prv
2814: ,pay_run_results prr
2815: ,pay_element_types_f pet
2816: ,pay_element_types_f_tl pettl
2817: ,pay_input_values_f piv
2818: ,pay_element_classifications pec
2819: WHERE prr.status IN ('P','PA')
2820: AND prv.run_result_id = prr.run_result_id
2821: AND prr.assignment_action_id = p_run_assign_action_id

Line 2886: ,pay_input_values_f piv

2882: SELECT prv.result_value value
2883: FROM pay_run_result_values prv
2884: ,pay_run_results prr
2885: ,pay_element_types_f pet
2886: ,pay_input_values_f piv
2887: ,pay_element_classifications pec
2888: WHERE prr.status IN ('P','PA')
2889: AND prv.run_result_id = prr.run_result_id
2890: AND prr.assignment_action_id = p_run_assign_action_id

Line 2928: pay_input_values_f piv

2924: CURSOR csr_chk_corr_feeds (p_element_type_id NUMBER) IS
2925: SELECT pbt.balance_name
2926: FROM pay_balance_types pbt,
2927: pay_balance_feeds_f pbf,
2928: pay_input_values_f piv
2929: WHERE pbf.balance_type_id = pbt.balance_type_id
2930: AND piv.input_value_id = pbf.input_value_id
2931: AND piv.element_type_id = p_element_type_id
2932: AND piv.name = 'Pay Value'

Line 3821: ,pay_input_values_f piv

3817: ,p_si_type VARCHAR2) IS
3818: SELECT prrv1.result_value si_type_name
3819: FROM pay_balance_feeds_f pbf
3820: ,pay_balance_types pbt
3821: ,pay_input_values_f piv
3822: ,pay_input_values_f piv1
3823: ,pay_input_values_f piv2
3824: ,pay_element_types_f pet
3825: ,pay_run_results prr

Line 3822: ,pay_input_values_f piv1

3818: SELECT prrv1.result_value si_type_name
3819: FROM pay_balance_feeds_f pbf
3820: ,pay_balance_types pbt
3821: ,pay_input_values_f piv
3822: ,pay_input_values_f piv1
3823: ,pay_input_values_f piv2
3824: ,pay_element_types_f pet
3825: ,pay_run_results prr
3826: ,pay_run_result_values prrv

Line 3823: ,pay_input_values_f piv2

3819: FROM pay_balance_feeds_f pbf
3820: ,pay_balance_types pbt
3821: ,pay_input_values_f piv
3822: ,pay_input_values_f piv1
3823: ,pay_input_values_f piv2
3824: ,pay_element_types_f pet
3825: ,pay_run_results prr
3826: ,pay_run_result_values prrv
3827: ,pay_run_result_values prrv1

Line 4519: ,pay_input_values_f piv

4515: ,p_classification_id NUMBER ) IS
4516: SELECT unique prr.start_date /*pay_nl_general.get_retro_period(prr.source_id,p_date_earned)*/ RDate -- Bug 5107780
4517: FROM pay_balance_feeds_f pbf
4518: ,pay_balance_types pbt
4519: ,pay_input_values_f piv
4520: ,pay_element_types_f pet
4521: ,pay_run_results prr
4522: WHERE pbf.balance_type_id = pbt.balance_type_id
4523: AND (pbt.balance_name like p_balance_name||'%'

Line 4564: ,pay_input_values_f piv

4560: SELECT sum(fnd_number.canonical_to_number(prrv.result_value)) result_value
4561: ,pet.processing_priority priority
4562: FROM pay_balance_feeds_f pbf
4563: ,pay_balance_types pbt
4564: ,pay_input_values_f piv
4565: ,pay_element_types_f pet
4566: -- ,pay_element_types_f_tl pettl Bug 5107780
4567: ,pay_run_results prr
4568: ,pay_run_result_values prrv

Line 4609: ,pay_input_values_f piv

4605: ,prrv1.result_value
4606: ,pet.processing_priority
4607: FROM pay_balance_feeds_f pbf
4608: ,pay_balance_types pbt
4609: ,pay_input_values_f piv
4610: ,pay_input_values_f piv1
4611: ,pay_input_values_f piv2
4612: ,pay_element_types_f pet
4613: -- ,pay_element_types_f_tl pettl Bug 5107780

Line 4610: ,pay_input_values_f piv1

4606: ,pet.processing_priority
4607: FROM pay_balance_feeds_f pbf
4608: ,pay_balance_types pbt
4609: ,pay_input_values_f piv
4610: ,pay_input_values_f piv1
4611: ,pay_input_values_f piv2
4612: ,pay_element_types_f pet
4613: -- ,pay_element_types_f_tl pettl Bug 5107780
4614: ,pay_run_results prr

Line 4611: ,pay_input_values_f piv2

4607: FROM pay_balance_feeds_f pbf
4608: ,pay_balance_types pbt
4609: ,pay_input_values_f piv
4610: ,pay_input_values_f piv1
4611: ,pay_input_values_f piv2
4612: ,pay_element_types_f pet
4613: -- ,pay_element_types_f_tl pettl Bug 5107780
4614: ,pay_run_results prr
4615: ,pay_run_result_values prrv