DBA Data[Home] [Help]

APPS.PAY_EMP_ACTION_ARCH dependencies on PAY_RUN_RESULT_VALUES

Line 586: pay_run_result_values prrv,

582: cp_assignment_id in number,
583: cp_date_earned in date ) is
584: select prrv.result_value
585: from pay_run_results prr,
586: pay_run_result_values prrv,
587: pay_input_values_f piv,
588: pay_assignment_actions paa,
589: pay_payroll_actions ppa
590: where prr.element_type_id + 0 = piv.element_type_id

Line 608: pay_run_result_values prrv,

604: cp_assignment_id in number,
605: cp_date_earned in date ) is
606: select prrv.result_value
607: from pay_run_results prr,
608: pay_run_result_values prrv,
609: pay_input_values_f piv,
610: pay_assignment_actions paa,
611: pay_payroll_actions ppa
612: where prr.element_type_id + 0 = piv.element_type_id