APPS.PAY_ROM_BUS dependencies on PAY_RUN_TYPES_F

Line 310: from pay_run_types_f prt

306: l_legislation_code pay_run_type_org_methods_f.legislation_code%TYPE := Null;
307: --
308: CURSOR csr_chk_user_run_type(p_leg_code varchar2) is
309: select 'Y'
310: from pay_run_types_f prt
311: where prt.run_type_id = p_run_type_id
312: and p_effective_date between effective_start_date
313: and effective_end_date
314: and ((prt.business_group_id is not null

Line 323: from pay_run_types_f prt

319: and prt.legislation_code is null));
320: --
321: CURSOR csr_chk_startup_run_type is
322: select 'Y'
323: from pay_run_types_f prt
324: where prt.run_type_id = p_run_type_id
325: and p_effective_date between effective_start_date
326: and effective_end_date
327: and prt.business_group_id is null

Line 334: from pay_run_types_f prt

330: or (prt.legislation_code is null));
331: --
332: CURSOR csr_chk_generic_run_type is
333: select 'Y'
334: from pay_run_types_f prt
335: where prt.run_type_id = p_run_type_id
336: and p_effective_date between effective_start_date
337: and effective_end_date
338: and prt.business_group_id is null

Line 957: (p_base_table_name => 'pay_run_types_f'

953: raise l_integrity_error;
954: End If;
955: If ((nvl(p_run_type_id, hr_api.g_number) <> hr_api.g_number) and
956: NOT (dt_api.check_min_max_dates
957: (p_base_table_name => 'pay_run_types_f'
958: ,p_base_key_column => 'RUN_TYPE_ID'
959: ,p_base_key_value => p_run_type_id
960: ,p_from_date => p_validation_start_date
961: ,p_to_date => p_validation_end_date))) Then