DBA Data[Home] [Help]

APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 217: pay_run_result_values prrv,

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

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

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

Line 555: pay_run_result_values prrv

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