DBA Data[Home] [Help]

APPS.PER_ASG_BUS1 dependencies on PER_ASSIGNMENTS_F

Line 473: FROM per_business_groups pbg, per_assignments_f paf

469: p_validation_end_date in date) Is
470: --
471: CURSOR c_business_group_legislation IS -- cursor added for 6917434
472: SELECT pbg.legislation_code
473: FROM per_business_groups pbg, per_assignments_f paf
474: WHERE paf.assignment_id = p_assignment_id
475: AND paf.business_group_id = pbg.business_group_id;
476:
477: l_proc varchar2(72) := g_package||'dt_delete_validate';

Line 3821: ,p_assignment_category in per_assignments_f.assignment_category%TYPE

3817: PROCEDURE chk_assignment_category
3818: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3819: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3820: ,p_effective_date in date
3821: ,p_assignment_category in per_assignments_f.assignment_category%TYPE
3822: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3823: ,p_validation_start_date in date
3824: ,p_validation_end_date in date) IS
3825: --