DBA Data[Home] [Help]

APPS.HR_US_FF_UDFS dependencies on PAY_RUN_RESULTS

Line 3221: pay_run_results PRR,

3217:
3218: SELECT RRV.result_value
3219: INTO v_dedn_proc
3220: FROM pay_run_result_values RRV,
3221: pay_run_results PRR,
3222: pay_input_values_f IPV
3223: WHERE PRR.assignment_action_id = p_assact_id
3224: AND RRV.result_value <> 'A'
3225: AND RRV.run_result_id = PRR.run_result_id

Line 3616: pay_run_results RRS,

3612: --
3613: CURSOR get_grosses IS
3614: SELECT fnd_number.canonical_to_number(RRV.result_value)
3615: FROM pay_run_result_values RRV,
3616: pay_run_results RRS,
3617: pay_input_values_f IPV,
3618: pay_element_types_f ELT
3619: WHERE RRV.input_value_id = IPV.input_value_id
3620: AND RRV.run_result_id = RRS.run_result_id