APPS.PAY_ETU_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 494: from pay_element_types_f pet,

490: l_exists varchar2(1);
491: --
492: CURSOR csr_chk_user_element_type(p_leg_code varchar2) is
493: select 'Y'
494: from pay_element_types_f pet,
495: pay_run_types_f rty
496: where pet.element_type_id = p_element_type_id
497: and p_effective_date between pet.effective_start_date
498: and pet.effective_end_date

Line 522: from pay_element_types_f pet,

518: );
519: --
520: CURSOR csr_chk_startup_element_type is
521: select 'Y'
522: from pay_element_types_f pet,
523: pay_run_types_f rty
524: where pet.element_type_id = p_element_type_id
525: and p_effective_date between pet.effective_start_date
526: and pet.effective_end_date

Line 548: from pay_element_types_f pet,

544: );
545: --
546: CURSOR csr_chk_generic_element_type is
547: select 'Y'
548: from pay_element_types_f pet,
549: pay_run_types_f rty
550: where pet.element_type_id = p_element_type_id
551: and p_effective_date between pet.effective_start_date
552: and pet.effective_end_date

Line 873: (p_base_table_name => 'pay_element_types_f'

869: );
870: --
871: If ((nvl(p_element_type_id, hr_api.g_number) <> hr_api.g_number) and
872: NOT (dt_api.check_min_max_dates
873: (p_base_table_name => 'pay_element_types_f'
874: ,p_base_key_column => 'ELEMENT_TYPE_ID'
875: ,p_base_key_value => p_element_type_id
876: ,p_from_date => p_validation_start_date
877: ,p_to_date => p_validation_end_date))) Then