DBA Data[Home] [Help]

APPS.PAY_US_EMP_BALADJ_CLEANUP dependencies on PAY_ELEMENT_TYPES_F

Line 212: where exists (select 1 from pay_element_types_f pet,

208:
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

Line 243: select element_type_id from pay_element_types_f

239: IS
240: ln_element_type_id NUMBER;
241:
242: cursor get_element_type_id (cp_elment_name in varchar2) is
243: select element_type_id from pay_element_types_f
244: where element_name = cp_elment_name
245: and legislation_code = 'US';
246:
247: BEGIN