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_RUN_RESULT_VALUES

Line 1581: FROM pay_run_result_values prv

1577: CURSOR csr_element_si_type_value(p_assignment_action_id NUMBER
1578: ,p_effective_date DATE) IS
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

Line 1585: ,pay_run_result_values prv1

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
1589: AND prr.assignment_action_id = p_assignment_action_id

Line 1624: from pay_run_result_values prrv

1620: --Cursor which gets the previous year income given assignment action id of payroll run
1621: Cursor get_prev_year_salary (p_asg_act_id number
1622: ,p_date_earned date) is
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

Line 2140: FROM pay_run_result_values prv

2136: CURSOR csr_element_values (p_assignment_action_id NUMBER
2137: ,p_element_type_id NUMBER
2138: ,p_input_value_id NUMBER) IS
2139: SELECT prv.result_value
2140: FROM pay_run_result_values prv
2141: ,pay_run_results prr
2142: WHERE prr.status IN ('P','PA')
2143: AND prv.run_result_id = prr.run_result_id
2144: AND prr.assignment_action_id = p_assignment_action_id

Line 2156: FROM pay_run_result_values prv

2152: ,p_si_type VARCHAR2
2153: ,p_effective_date DATE) IS
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')

Line 2159: ,pay_run_result_values prv1

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
2163: AND prr.element_type_id = p_element_type_id

Line 2193: pay_run_result_values prv

2189: ,p_si_type VARCHAR2
2190: ,p_effective_date DATE) IS
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

Line 2196: ,pay_run_result_values prv1

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
2200: AND prr.assignment_action_id = p_assignment_action_id

Line 2442: ,pay_run_result_values prrv

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
2444: WHERE pbf.balance_type_id = pbt.balance_type_id
2445: AND pbt.balance_name = p_balance_name
2446: AND piv.input_value_id = pbf.input_value_id

Line 2443: ,pay_run_result_values prrv1

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
2444: WHERE pbf.balance_type_id = pbt.balance_type_id
2445: AND pbt.balance_name = p_balance_name
2446: AND piv.input_value_id = pbf.input_value_id
2447: AND (piv.name ='Pay Value'

Line 2742: FROM pay_run_result_values prv

2738: ,pet.processing_priority priority
2739: ,pet.business_group_id business_group_id
2740: ,prv.run_result_id run_result_id
2741:
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

Line 2775: FROM pay_run_result_values prv

2771: ,p_element_name VARCHAR2
2772: ,p_input_value_name VARCHAR2
2773: ,p_date_earned DATE) IS
2774: SELECT unique prr.start_date --(pay_nl_general.get_retro_period(prr.source_id,p_date_earned)) Bug 5107780
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

Line 2813: FROM pay_run_result_values prv

2809: ,nvl(pettl.reporting_name,pettl.element_name) reporting_name
2810: ,pet.processing_priority priority
2811: ,pet.business_group_id business_group_id
2812: ,prv.run_result_id run_result_id /* 4389520*/
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

Line 2883: FROM pay_run_result_values prv

2879: ,p_element_name VARCHAR2
2880: ,p_input_value_name VARCHAR2
2881: ,p_date_earned DATE) IS
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

Line 2949: l_pecentage_rate pay_run_result_values.result_value%TYPE;

2945: l_index NUMBER;
2946: l_temp_index NUMBER;
2947: l_travel_flag NUMBER;
2948: l_retro_travel_flag NUMBER;
2949: l_pecentage_rate pay_run_result_values.result_value%TYPE;
2950: l_sum_standard_rate varchar2(255);
2951: l_sum_special_rate varchar2(255);
2952: l_sum_payable varchar2(255);
2953: l_date varchar2(60);

Line 3826: ,pay_run_result_values prrv

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
3828: WHERE pbf.balance_type_id = pbt.balance_type_id
3829: AND pbt.balance_name like p_balance_name||'%'
3830: AND piv.input_value_id = pbf.input_value_id

Line 3827: ,pay_run_result_values prrv1

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
3828: WHERE pbf.balance_type_id = pbt.balance_type_id
3829: AND pbt.balance_name like p_balance_name||'%'
3830: AND piv.input_value_id = pbf.input_value_id
3831: AND piv.name ='Pay Value'

Line 3931: l_si_type_name pay_run_result_values.result_value%TYPE;

3927: l_archive_flag VARCHAR2(10);
3928: l_payable NUMBER;
3929: l_sum_payable NUMBER;
3930: l_si_type pay_action_contexts.context_value%TYPE;
3931: l_si_type_name pay_run_result_values.result_value%TYPE;
3932: l_def_bal_id NUMBER;
3933:
3934: l_standard_rate_run NUMBER;
3935: l_sum_standard_rate_run NUMBER;

Line 4568: ,pay_run_result_values prrv

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
4569: ,pay_element_entries_f pee
4570: WHERE pbf.balance_type_id = pbt.balance_type_id
4571: AND prr.source_id = pee.element_entry_id
4572: AND pee.CREATOR_TYPE = p_creator_type

Line 4615: ,pay_run_result_values prrv

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
4616: ,pay_run_result_values prrv1
4617: ,pay_run_result_values prrv2
4618: ,pay_element_entries_f pee
4619: WHERE pbf.balance_type_id = pbt.balance_type_id

Line 4616: ,pay_run_result_values prrv1

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
4616: ,pay_run_result_values prrv1
4617: ,pay_run_result_values prrv2
4618: ,pay_element_entries_f pee
4619: WHERE pbf.balance_type_id = pbt.balance_type_id
4620: AND prr.source_id = pee.element_entry_id

Line 4617: ,pay_run_result_values prrv2

4613: -- ,pay_element_types_f_tl pettl Bug 5107780
4614: ,pay_run_results prr
4615: ,pay_run_result_values prrv
4616: ,pay_run_result_values prrv1
4617: ,pay_run_result_values prrv2
4618: ,pay_element_entries_f pee
4619: WHERE pbf.balance_type_id = pbt.balance_type_id
4620: AND prr.source_id = pee.element_entry_id
4621: AND pee.CREATOR_TYPE = p_creator_type