DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PAY_RUN_RESULTS

Line 4597: ,pay_run_results prr

4593: )
4594: IS
4595: SELECT to_number(prrv.result_value) result
4596: FROM pay_run_result_values prrv
4597: ,pay_run_results prr
4598: WHERE prrv.run_result_id = prr.run_result_id
4599: AND prr.assignment_action_id = p_asg_act_id
4600: AND prr.source_id = p_element_entry_id
4601: AND prrv.input_value_id = p_input_value_id ;

Line 5069: pay_run_results prr,

5065: SELECT prrv.result_value
5066: FROM
5067: pay_element_types_f pet,
5068: pay_input_values_f piv,
5069: pay_run_results prr,
5070: pay_run_result_values prrv
5071: WHERE
5072: pet.element_name = 'PGGM Pensions General Information'
5073: and piv.name ='Incidental Worker'