DBA Data[Home] [Help]

APPS.HR_CA_FF_UDFS dependencies on PAY_RUN_RESULTS

Line 2871: pay_run_results PRR,

2867:
2868: SELECT RRV.result_value
2869: INTO v_dedn_proc
2870: FROM pay_run_result_values RRV,
2871: pay_run_results PRR,
2872: pay_input_values_f IPV
2873: WHERE PRR.assignment_action_id = p_assact_id
2874: AND RRV.result_value <> 'A'
2875: AND RRV.run_result_id = PRR.run_result_id

Line 3249: pay_run_results RRS,

3245: --
3246: CURSOR get_grosses IS
3247: SELECT RRV.result_value
3248: FROM pay_run_result_values RRV,
3249: pay_run_results RRS,
3250: pay_input_values_f IPV,
3251: pay_element_types_f ELT
3252: WHERE RRV.input_value_id = IPV.input_value_id
3253: AND RRV.run_result_id = RRS.run_result_id