APPS.PAY_RTU_BUS dependencies on PAY_RUN_TYPES_F

Line 308: from pay_run_types_f prt

304: --
305: CURSOR csr_chk_valid_parent
306: is
307: select 'Y'
308: from pay_run_types_f prt
309: where prt.run_type_id = p_parent_run_type_id
310: and prt.run_method = 'C'
311: and p_effective_date between prt.effective_start_date
312: and prt.effective_end_date

Line 491: from pay_run_types_f prt

487: is
488: select prt.business_group_id
489: , prt.legislation_code
490: , prt.run_type_id
491: from pay_run_types_f prt
492: where prt.run_type_id = p_child_run_type_id
493: and p_effective_date between prt.effective_start_date
494: and prt.effective_end_date;
495: --

Line 889: (p_base_table_name => 'pay_run_types_f'

885: );
886: --
887: If ((nvl(p_parent_run_type_id, hr_api.g_number) <> hr_api.g_number) and
888: NOT (dt_api.check_min_max_dates
889: (p_base_table_name => 'pay_run_types_f'
890: ,p_base_key_column => 'RUN_TYPE_ID'
891: ,p_base_key_value => p_parent_run_type_id
892: ,p_from_date => p_validation_start_date
893: ,p_to_date => p_validation_end_date))) Then

Line 899: (p_base_table_name => 'pay_run_types_f'

895: raise l_integrity_error;
896: End If;
897: If ((nvl(p_child_run_type_id, hr_api.g_number) <> hr_api.g_number) and
898: NOT (dt_api.check_min_max_dates
899: (p_base_table_name => 'pay_run_types_f'
900: ,p_base_key_column => 'RUN_TYPE_ID'
901: ,p_base_key_value => p_child_run_type_id
902: ,p_from_date => p_validation_start_date
903: ,p_to_date => p_validation_end_date))) Then