APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 277: ,pay_element_types_f pet

273: ,ppa.payroll_id
274: ,pap.business_group_id
275: ,pap.accrual_plan_id
276: FROM pay_accrual_plans pap
277: ,pay_element_types_f pet
278: ,pay_element_links_f pel
279: ,pay_element_entries_f pee
280: ,pay_assignment_actions paa
281: ,pay_payroll_actions ppa

Line 463: ,pay_element_types_f pet

459: ,pay_payroll_actions ppa
460: ,pay_run_results prr
461: ,pay_run_result_values prrv
462: ,per_time_periods ptp
463: ,pay_element_types_f pet
464: ,pay_input_values_f piv
465: ,pay_element_entries_f pee
466: ,per_absence_attendance_types pat
467: ,per_absence_attendances pab

Line 626: , pay_element_types_f pet

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

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

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

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