DBA Data[Home] [Help]

APPS.PAY_CN_PAYSLIP dependencies on PAY_RUN_RESULTS

Line 539: -- 115.3 15-Apr-2010 dduvvuri Added condition on pay_run_results to pick up results

535: -- run result value exists or not --
536: -- 115.2 28-May-2008 dduvvuri Added fnd_number.canonical_to_number
537: -- in the cursor before selecting the
538: -- run result value.
539: -- 115.3 15-Apr-2010 dduvvuri Added condition on pay_run_results to pick up results
540: -- whose status = P,PA
541: --------------------------------------------------------------------------
542: --
543: PROCEDURE get_run_result_value

Line 560: ,pay_run_results prr

556: FROM pay_assignment_actions paa
557: ,pay_payroll_actions ppa
558: ,pay_element_types_f pet
559: ,pay_input_values_f piv
560: ,pay_run_results prr
561: ,pay_run_result_values prrv
562: WHERE paa.assignment_action_id = p_assignment_action_id
563: AND ppa.payroll_action_id = paa.payroll_action_id
564: AND ppa.action_type IN ('Q','R')