DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PAY_RUN_RESULT_VALUES

Line 4596: FROM pay_run_result_values prrv

4592: ,p_asg_act_id NUMBER
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

Line 5070: pay_run_result_values prrv

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'
5074: and piv.element_type_id=pet.element_type_id