APPS.PAY_ECU_BUS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 373: from pay_element_classifications ecl

369: ) IS
370: --
371: CURSOR csr_chk_user_ele_class(p_leg_code varchar2) is
372: select 'Y'
373: from pay_element_classifications ecl
374: where ecl.classification_id = p_classification_id
375: and ((ecl.business_group_id is not null
376: and ecl.business_group_id = p_business_group_id)
377: or (ecl.legislation_code is not null

Line 384: from pay_element_classifications ecl

380: and ecl.legislation_code is null));
381: --
382: CURSOR csr_chk_startup_ele_class is
383: select 'Y'
384: from pay_element_classifications ecl
385: where ecl.classification_id = p_classification_id
386: and ecl.business_group_id is null
387: and ((p_legislation_code is not null
388: and ecl.legislation_code = p_legislation_code)

Line 393: from pay_element_classifications ecl

389: or (ecl.legislation_code is null));
390: --
391: CURSOR csr_chk_generic_ele_class is
392: select 'Y'
393: from pay_element_classifications ecl
394: where ecl.classification_id = p_classification_id
395: and ecl.business_group_id is null
396: and ecl.legislation_code is null;
397: --