DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_DPSA dependencies on PAY_RUN_RESULT_VALUES

Line 484: ,pay_run_result_values TARGET

480: ,pay_assignment_actions act1
481: ,pay_action_interlocks pai
482: ,per_all_assignments_f as1
483: ,hr_soft_coding_keyflex hsck
484: ,pay_run_result_values TARGET
485: ,pay_run_results RR
486: WHERE ppa.payroll_action_id = p_payroll_action_id
487: AND appa.effective_date BETWEEN l_canonical_start_date
488: AND l_canonical_end_date

Line 543: ,pay_run_result_values TARGET

539: ,pay_assignment_actions act
540: ,pay_assignment_actions act1
541: ,pay_action_interlocks pai
542: ,per_all_assignments_f as1
543: ,pay_run_result_values TARGET
544: ,pay_run_results RR
545: WHERE ppa.payroll_action_id = p_payroll_action_id
546: AND appa.effective_date BETWEEN l_canonical_start_date
547: AND l_canonical_end_date

Line 900: pay_run_result_values prrv

896: pay_assignment_actions paa,
897: pay_run_results prr,
898: pay_element_types_f petf,
899: pay_input_values_f pivf,
900: pay_run_result_values prrv
901: WHERE paa.assignment_id = p_assignment_id
902: AND paa.assignment_action_id = prr.assignment_action_id
903: AND prr.element_type_id = petf.element_type_id
904: AND petf.element_name = p_element_name