DBA Data[Home] [Help]

APPS.PAY_ZA_EMP201 dependencies on PAY_ELEMENT_TYPES_F

Line 767: , pay_element_types_f pet

763: cursor csr_tax_status (p_payroll_action_id number ) is
764: select prrv.result_value
765: from pay_payroll_actions ppa
766: , pay_assignment_actions paa
767: , pay_element_types_f pet
768: , pay_input_values_f piv
769: , pay_run_results prr
770: , pay_run_result_values prrv
771: where ppa.payroll_action_id = p_payroll_action_id

Line 789: , pay_element_types_f pet

785: , p_effective_date date) is
786: select peev.screen_entry_value
787: from pay_element_entry_values_f peev
788: , pay_element_entries_f peef
789: , pay_element_types_f pet
790: , pay_input_values_f piv
791: where
792: pet.legislation_code = 'ZA'
793: and pet.element_name = 'ZA_Tax'