DBA Data[Home] [Help]

APPS.HR_US_FF_UDFS dependencies on PAY_RUN_RESULTS

Line 3212: pay_run_results PRR,

3208:
3209: SELECT RRV.result_value
3210: INTO v_dedn_proc
3211: FROM pay_run_result_values RRV,
3212: pay_run_results PRR,
3213: pay_input_values_f IPV
3214: WHERE PRR.assignment_action_id = p_assact_id
3215: AND RRV.result_value <> 'A'
3216: AND RRV.run_result_id = PRR.run_result_id

Line 3607: pay_run_results RRS,

3603: --
3604: CURSOR get_grosses IS
3605: SELECT fnd_number.canonical_to_number(RRV.result_value)
3606: FROM pay_run_result_values RRV,
3607: pay_run_results RRS,
3608: pay_input_values_f IPV,
3609: pay_element_types_f ELT
3610: WHERE RRV.input_value_id = IPV.input_value_id
3611: AND RRV.run_result_id = RRS.run_result_id