DBA Data[Home] [Help]

APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 218: pay_run_result_values prrv,

214: FROM pay_action_interlocks pai, -- run interlock by archive assact
215: pay_assignment_actions rpaa, -- run assact
216: pay_payroll_actions rppa, -- run pact
217: pay_run_results prr,
218: pay_run_result_values prrv,
219: pay_balance_feeds_f pbf,
220: pay_element_types_f_tl pettl
221: WHERE pai.locking_action_id = cp_arch_assignment_action_id
222: AND rpaa.assignment_action_id = pai.locked_action_id

Line 506: -- This procedure archives from PAY_RUN_RESULT_VALUES while core procedure

502: -- |--------------------------< setup_eit_element >---------------------------|
503: -- +--------------------------------------------------------------------------+
504: --
505: -- This procedure is to archive element which is defined at Organization EIT.
506: -- This procedure archives from PAY_RUN_RESULT_VALUES while core procedure
507: -- pay_emp_action_arch.get_employee_other_info archives from PAY_ELEMENT_ENTRY_VALUES_F.
508: -- These archived data is displayed on Further Information region.
509: -- Note: The condition to get archive data is the same as global package,
510: -- pay_emp_action_arch.get_employee_other_info.

Line 556: pay_run_result_values prrv

552: hr_organization_information hoi,
553: pay_element_types_f pet,
554: pay_element_types_f_tl pettl,
555: pay_input_values_f piv,
556: pay_run_result_values prrv
557: WHERE rpai.locking_action_id = cp_arch_assignment_action_id
558: AND rpaa.assignment_action_id = rpai.locked_action_id
559: AND rppa.payroll_action_id = rpaa.payroll_action_id
560: AND rppa.action_type in ('R', 'Q', 'B')