APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 9689: ,pay_run_result_values rrv

9685: ,prr.element_entry_id
9686: ,min(decode(piv.name, 'Report Type', rrv.RESULT_VALUE, null)) Retro_type
9687: ,min(decode(piv.name, 'Period', rrv.RESULT_VALUE, null)) Period
9688: FROM pay_run_results prr
9689: ,pay_run_result_values rrv
9690: ,pay_input_values_f piv
9691: ,pay_element_types_f pet
9692: WHERE prr.run_result_id = rrv.run_result_id
9693: AND rrv.input_value_id + 0 = piv.input_value_id

Line 9960: FROM pay_run_result_values prrv

9956: -- /*LC 2010 */ begin
9957: CURSOR csr_get_small_job_detail(c_assignment_action_id NUMBER
9958: ,c_eff_date DATE) IS
9959: SELECT prrv.result_value
9960: FROM pay_run_result_values prrv
9961: ,pay_input_values_f piv
9962: ,pay_element_types_f pet
9963: ,pay_run_results prr
9964: WHERE pet.element_name = 'Small Job Indicator'

Line 10052: l_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/

10048: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
10049: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
10050: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2013*/
10051: --
10052: l_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
10053: l_assg_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
10054: --
10055: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
10056: l_event_group_id pay_event_groups.event_group_id%TYPE;

Line 10053: l_assg_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/

10049: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
10050: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2013*/
10051: --
10052: l_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
10053: l_assg_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
10054: --
10055: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
10056: l_event_group_id pay_event_groups.event_group_id%TYPE;
10057: l_assignment_id NUMBER;

Line 14159: FROM pay_run_result_values prrv

14155: -- /*LC 2010 */ begin
14156: CURSOR csr_get_small_job_detail(c_assignment_action_id NUMBER
14157: ,c_eff_date DATE) IS
14158: SELECT prrv.result_value
14159: FROM pay_run_result_values prrv
14160: ,pay_input_values_f piv
14161: ,pay_element_types_f pet
14162: ,pay_run_results prr
14163: WHERE pet.element_name = 'Small Job Indicator'

Line 14249: l_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/

14245: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
14246: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
14247: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2013*/
14248: --
14249: l_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
14250: l_assg_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
14251: --
14252: l_assignment_id NUMBER;
14253: l_chk VARCHAR2(2);

Line 14250: l_assg_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/

14246: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
14247: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2013*/
14248: --
14249: l_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
14250: l_assg_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
14251: --
14252: l_assignment_id NUMBER;
14253: l_chk VARCHAR2(2);
14254: p_date DATE;