DBA Data[Home] [Help]

APPS.PAY_ZA_EOY_VAL dependencies on PAY_RUN_RESULTS

Line 566: pay_run_results prr,

562: FROM pay_assignment_actions paa,
563: pay_payroll_actions ppa,
564: pay_element_types_f pet,
565: pay_input_values_f piv,
566: pay_run_results prr,
567: pay_run_result_values prv
568: Where paa.assignment_action_id = p_asgn_ac_id
569: and prr.assignment_Action_id = paa.assignment_action_id
570: and pet.element_type_id = prr.element_type_id

Line 660: , pay_run_results RR

656: SELECT ELEM.element_name element_name,
657: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(TARGET.RESULT_VALUE,0)))))
658: from pay_balance_feeds_f FEED
659: , pay_run_result_values TARGET
660: , pay_run_results RR
661: , per_time_periods PPTP
662: , per_time_periods BPTP
663: , pay_payroll_actions PACT
664: , pay_assignment_actions ASSACT