DBA Data[Home] [Help]

APPS.PAY_ZA_EOY_VAL dependencies on PAY_RUN_RESULTS

Line 747: pay_run_results prr,

743: FROM pay_assignment_actions paa,
744: pay_payroll_actions ppa,
745: pay_element_types_f pet,
746: pay_input_values_f piv,
747: pay_run_results prr,
748: pay_run_result_values prv
749: Where paa.assignment_action_id = p_asgn_ac_id
750: and prr.assignment_Action_id = paa.assignment_action_id
751: and pet.element_type_id = prr.element_type_id

Line 840: , pay_run_results RR

836: SELECT ELEM.element_name element_name,
837: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(TARGET.RESULT_VALUE,0)))))
838: from pay_balance_feeds_f FEED
839: , pay_run_result_values TARGET
840: , pay_run_results RR
841: , per_time_periods PPTP
842: , per_time_periods BPTP
843: , pay_payroll_actions PACT
844: , pay_assignment_actions ASSACT

Line 4147: , pay_run_results RR

4143: SELECT ELEM.element_name element_name,
4144: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(TARGET.RESULT_VALUE,0)))))
4145: from pay_balance_feeds_f FEED
4146: , pay_run_result_values TARGET
4147: , pay_run_results RR
4148: , per_time_periods PPTP
4149: , per_time_periods BPTP
4150: , pay_payroll_actions PACT
4151: , pay_assignment_actions ASSACT