APPS.PAY_NO_SUPPORT_ORDER dependencies on PAY_RUN_RESULT_VALUES

Line 515: ,pay_run_result_values prrv

511: ,pay_payroll_actions ppa2
512: ,pay_payroll_actions ppa3
513: ,per_all_assignments_f asg
514: ,pay_run_results prr
515: ,pay_run_result_values prrv
516: ,pay_input_values_f inpv
517: ,pay_action_interlocks pai
518:
519: WHERE -- initial conditions

Line 760: ,pay_run_result_values prrv1

756: ,pay_payroll_actions ppa
757: ,per_all_assignments_f asg
758: ,per_all_people_f per
759: ,pay_run_results prr
760: ,pay_run_result_values prrv1
761: ,pay_run_result_values prrv2
762:
763: WHERE assact.ASSIGNMENT_ACTION_ID = p_assignment_action_id
764: AND assact.ASSIGNMENT_ID = asg.ASSIGNMENT_ID

Line 761: ,pay_run_result_values prrv2

757: ,per_all_assignments_f asg
758: ,per_all_people_f per
759: ,pay_run_results prr
760: ,pay_run_result_values prrv1
761: ,pay_run_result_values prrv2
762:
763: WHERE assact.ASSIGNMENT_ACTION_ID = p_assignment_action_id
764: AND assact.ASSIGNMENT_ID = asg.ASSIGNMENT_ID
765: AND ppa.date_earned between asg.EFFECTIVE_START_DATE and asg.EFFECTIVE_END_DATE

Line 787: FROM pay_run_result_values

783: -- cursor to get the assignment,person details and run values
784:
785: CURSOR csr_result_values ( p_run_res_id NUMBER , p_inp_val_id NUMBER ) IS
786: SELECT result_value
787: FROM pay_run_result_values
788: WHERE RUN_RESULT_ID = p_run_res_id
789: AND INPUT_VALUE_ID = p_inp_val_id ;
790:
791: