APPS.PAY_ETU_BUS dependencies on PAY_ELEMENT_CLASS_USAGES_F

Line 507: and ((exists (select 'Y' from pay_element_class_usages_f ecu

503: or (pet.business_group_id is null
504: and pet.legislation_code is null))
505: -- This condition is to check the element if any classification usage(s) is/are defined for the given
506: -- runtype then we need to allow only the elements which belongs to the classification(s).
507: and ((exists (select 'Y' from pay_element_class_usages_f ecu
508: where rty.run_type_id = ecu.run_type_id
509: and ecu.classification_id = pet.classification_id
510: and p_effective_date between ecu.effective_start_date and ecu.effective_end_date
511: and nvl(ecu.legislation_code,nvl(p_leg_code, ' ')) = nvl(p_leg_code, ' ')

Line 513: or ( not exists (select 'Y' from pay_element_class_usages_f ecu

509: and ecu.classification_id = pet.classification_id
510: and p_effective_date between ecu.effective_start_date and ecu.effective_end_date
511: and nvl(ecu.legislation_code,nvl(p_leg_code, ' ')) = nvl(p_leg_code, ' ')
512: and nvl(ecu.business_group_id, nvl(p_business_group_id, -1)) = nvl(p_business_group_id,-1)))
513: or ( not exists (select 'Y' from pay_element_class_usages_f ecu
514: where rty.run_type_id = ecu.run_type_id
515: and p_effective_date between ecu.effective_start_date and ecu.effective_end_date
516: and nvl(ecu.legislation_code,nvl(p_leg_code, ' ')) = nvl(p_leg_code, ' ')
517: and nvl(ecu.business_group_id, nvl(p_business_group_id, -1)) = nvl(p_business_group_id,-1)))

Line 533: and ((exists (select 'Y' from pay_element_class_usages_f ecu

529: and pet.legislation_code = p_legislation_code)
530: or (pet.legislation_code is null))
531: -- This condition is to check the element, if any classification usage(s) is/are defined for the given
532: -- runtype then we need to allow only the elements which belongs to the classification(s).
533: and ((exists (select 'Y' from pay_element_class_usages_f ecu
534: where rty.run_type_id = ecu.run_type_id
535: and ecu.classification_id = pet.classification_id
536: and p_effective_date between ecu.effective_start_date and ecu.effective_end_date
537: and nvl(ecu.legislation_code,nvl(p_legislation_code, ' ')) = nvl(p_legislation_code, ' ')

Line 539: or ( not exists (select 'Y' from pay_element_class_usages_f ecu

535: and ecu.classification_id = pet.classification_id
536: and p_effective_date between ecu.effective_start_date and ecu.effective_end_date
537: and nvl(ecu.legislation_code,nvl(p_legislation_code, ' ')) = nvl(p_legislation_code, ' ')
538: and nvl(ecu.business_group_id, nvl(p_business_group_id, -1)) = nvl(p_business_group_id,-1)))
539: or ( not exists (select 'Y' from pay_element_class_usages_f ecu
540: where rty.run_type_id = ecu.run_type_id
541: and p_effective_date between ecu.effective_start_date and ecu.effective_end_date
542: and nvl(ecu.legislation_code,nvl(p_legislation_code, ' ')) = nvl(p_legislation_code, ' ')
543: and nvl(ecu.business_group_id, nvl(p_business_group_id, -1)) = nvl(p_business_group_id,-1)))

Line 557: and ((exists (select 'Y' from pay_element_class_usages_f ecu

553: and pet.business_group_id is null
554: and pet.legislation_code is null
555: -- This condition is to check the element, if any classification usage(s) is/are defined for the given
556: -- runtype then we need to allow only the elements which belongs to the classification(s).
557: and ((exists (select 'Y' from pay_element_class_usages_f ecu
558: where rty.run_type_id = ecu.run_type_id
559: and ecu.classification_id = pet.classification_id
560: and p_effective_date between ecu.effective_start_date and ecu.effective_end_date
561: and nvl(ecu.legislation_code,nvl(p_legislation_code, ' ')) = nvl(p_legislation_code, ' ')

Line 563: or ( not exists (select 'Y' from pay_element_class_usages_f ecu

559: and ecu.classification_id = pet.classification_id
560: and p_effective_date between ecu.effective_start_date and ecu.effective_end_date
561: and nvl(ecu.legislation_code,nvl(p_legislation_code, ' ')) = nvl(p_legislation_code, ' ')
562: and nvl(ecu.business_group_id, nvl(p_business_group_id, -1)) = nvl(p_business_group_id,-1)))
563: or ( not exists (select 'Y' from pay_element_class_usages_f ecu
564: where rty.run_type_id = ecu.run_type_id
565: and p_effective_date between ecu.effective_start_date and ecu.effective_end_date
566: and nvl(ecu.legislation_code,nvl(p_legislation_code, ' ')) = nvl(p_legislation_code, ' ')
567: and nvl(ecu.business_group_id, nvl(p_business_group_id, -1)) = nvl(p_business_group_id,-1)))