APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 352: ,pay_element_types_f pet

348: ,ppa.payroll_id
349: ,pap.business_group_id
350: ,pap.accrual_plan_id
351: FROM pay_accrual_plans pap
352: ,pay_element_types_f pet
353: ,pay_element_links_f pel
354: ,pay_element_entries_f pee
355: ,pay_assignment_actions paa
356: ,pay_payroll_actions ppa

Line 555: ,pay_element_types_f pet

551: ,pay_payroll_actions ppa
552: ,pay_run_results prr
553: ,pay_run_result_values prrv
554: ,per_time_periods ptp
555: ,pay_element_types_f pet
556: ,pay_input_values_f piv
557: ,pay_element_entries_f pee
558: ,per_absence_attendance_types pat
559: ,per_absence_attendances pab

Line 724: , pay_element_types_f pet

720: , pay_assignment_actions paa
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')

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 906: FROM pay_element_types_f pet,

902: )
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

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');