[Home] [Help]
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
9694: AND piv.element_type_id = pet.element_type_id
9855: ,c_assignment_id NUMBER
9856: ,c_eff_date DATE) IS
9857: SELECT peev.screen_entry_value
9858: FROM pay_element_types_f pet
9859: ,pay_input_values_f piv
9860: ,pay_element_entries_f peef
9861: ,pay_element_entry_values_f peev
9862: WHERE pet.element_name = c_element_name
9863: AND pet.element_type_id = piv.element_type_id
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'
9965: AND pet.element_type_id = piv.element_type_id
14063: ,c_assignment_id NUMBER
14064: ,c_eff_date DATE) IS
14065: SELECT peev.screen_entry_value
14066: FROM pay_element_types_f pet
14067: ,pay_input_values_f piv
14068: ,pay_element_entries_f peef
14069: ,pay_element_entry_values_f peev
14070: WHERE pet.element_name = c_element_name
14071: AND pet.element_type_id = piv.element_type_id
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'
14164: AND pet.element_type_id = piv.element_type_id