DBA Data[Home] [Help]

APPS.PAY_US_EMP_BALADJ_CLEANUP dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 213: pay_element_classifications pec

209: cursor c_element_category(cp_business_group_id in number
210: ,cp_element_category in varchar2) is
211: select 'Y' from dual
212: where exists (select 1 from pay_element_types_f pet,
213: pay_element_classifications pec
214: where pet.classification_id = pec.classification_id
215: and pet.business_group_id = cp_business_group_id
216: and pet.element_information1 = cp_element_category
217: and pec.classification_name = 'Pre-Tax Deductions'