DBA Data[Home] [Help]

APPS.HR_CA_FF_UDFS dependencies on PAY_RUN_RESULTS

Line 2908: pay_run_results PRR,

2904:
2905: SELECT RRV.result_value
2906: INTO v_dedn_proc
2907: FROM pay_run_result_values RRV,
2908: pay_run_results PRR,
2909: pay_input_values_f IPV
2910: WHERE PRR.assignment_action_id = p_assact_id
2911: AND RRV.result_value <> 'A'
2912: AND RRV.run_result_id = PRR.run_result_id

Line 3286: pay_run_results RRS,

3282: --
3283: CURSOR get_grosses IS
3284: SELECT RRV.result_value
3285: FROM pay_run_result_values RRV,
3286: pay_run_results RRS,
3287: pay_input_values_f IPV,
3288: pay_element_types_f ELT
3289: WHERE RRV.input_value_id = IPV.input_value_id
3290: AND RRV.run_result_id = RRS.run_result_id