DBA Data[Home] [Help]

APPS.PER_IN_ORG_INFO_LEG_HOOK dependencies on PAY_ELEMENT_TYPES_F

Line 3217: ,pay_element_types_f pet

3213: WHERE EXISTS
3214: ( SELECT 1
3215: FROM hr_organization_information hoi
3216: ,pay_element_entries_f pee
3217: ,pay_element_types_f pet
3218: WHERE pet.element_name = 'Income Tax Challan Information'
3219: AND pet.legislation_code = 'IN'
3220: AND pee.element_type_id = pet.element_type_id
3221: AND pay_in_utils.get_ee_value(pee.element_entry_id,'Challan or Voucher Number') like '% - %'||hoi.org_information3||'% - %'||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR')