DBA Data[Home] [Help]

APPS.PAY_IN_FF_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 548: pay_element_types_f pet

544: SELECT pap.accrual_plan_id
545: FROM pay_accrual_plans pap,
546: pay_element_entries_f pee,
547: pay_element_links_f pel,
548: pay_element_types_f pet
549: WHERE pee.assignment_id = p_assignment_id
550: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
551: AND pel.element_link_id = pee.element_link_id
552: AND pel.element_type_id = pet.element_type_id

Line 789: pay_element_types_f pet,

785: CURSOR c_80dd_80_percent is
786: SELECT count (*)
787: FROM pay_element_entry_values_f pev,
788: pay_element_entries_f pee,
789: pay_element_types_f pet,
790: pay_input_values_f piv
791: WHERE pet.element_name like 'Deduction under Section 80DD'
792: AND pet.legislation_code = 'IN'
793: AND pet.element_type_id = piv.element_type_id