APPS.PAY_ETU_BUS dependencies on PAY_RUN_TYPES_F

Line 322: from pay_run_types_f prt

318: l_exists varchar2(1);
319: --
320: CURSOR csr_chk_user_run_type(p_leg_code varchar2) is
321: select 'Y'
322: from pay_run_types_f prt
323: where prt.run_type_id = p_run_type_id
324: and p_effective_date between prt.effective_start_date
325: and prt.effective_end_date
326: and ((prt.business_group_id is not null

Line 335: from pay_run_types_f prt

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

Line 346: from pay_run_types_f prt

342: or (prt.legislation_code is null));
343: --
344: CURSOR csr_chk_generic_run_type is
345: select 'Y'
346: from pay_run_types_f prt
347: where prt.run_type_id = p_run_type_id
348: and p_effective_date between prt.effective_start_date
349: and prt.effective_end_date
350: and prt.business_group_id is null

Line 495: pay_run_types_f rty

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
499: and ((pet.business_group_id is not null

Line 523: pay_run_types_f rty

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
527: and pet.business_group_id is null

Line 549: pay_run_types_f rty

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
553: and pet.business_group_id is null

Line 883: (p_base_table_name => 'pay_run_types_f'

879: raise l_integrity_error;
880: End If;
881: If ((nvl(p_run_type_id, hr_api.g_number) <> hr_api.g_number) and
882: NOT (dt_api.check_min_max_dates
883: (p_base_table_name => 'pay_run_types_f'
884: ,p_base_key_column => 'RUN_TYPE_ID'
885: ,p_base_key_value => p_run_type_id
886: ,p_from_date => p_validation_start_date
887: ,p_to_date => p_validation_end_date))) Then