DBA Data[Home] [Help]

APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F_TL

Line 725: , pay_element_types_f_tl petl

721: , pay_run_results prr
722: , pay_run_result_values prrv
723: , pay_input_values_f piv
724: , pay_element_types_f pet
725: , pay_element_types_f_tl petl
726: , pay_element_classifications pec
727: ,pay_action_interlocks pai
728: WHERE ppa.action_type in ('R','Q')
729: AND ppa.action_status = 'C'

Line 907: pay_element_types_f_tl petl

903: IS
904: CURSOR csr_elem_name IS
905: SELECT petl.element_name
906: FROM pay_element_types_f pet,
907: pay_element_types_f_tl petl
908: WHERE pet.element_name = p_element_name
909: AND pet.legislation_code = 'CN'
910: AND pet.element_type_id = petl.element_type_id
911: AND petl.language = userenv('LANG');