DBA Data[Home] [Help]

APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F_TL

Line 627: , pay_element_types_f_tl petl

623: , pay_run_results prr
624: , pay_run_result_values prrv
625: , pay_input_values_f piv
626: , pay_element_types_f pet
627: , pay_element_types_f_tl petl
628: , pay_element_classifications pec
629: ,pay_action_interlocks pai
630: WHERE ppa.action_type in ('R','Q')
631: AND ppa.action_status = 'C'

Line 805: pay_element_types_f_tl petl

801: IS
802: CURSOR csr_elem_name IS
803: SELECT petl.element_name
804: FROM pay_element_types_f pet,
805: pay_element_types_f_tl petl
806: WHERE pet.element_name = p_element_name
807: AND pet.legislation_code = 'CN'
808: AND pet.element_type_id = petl.element_type_id
809: AND petl.language = userenv('LANG');