APPS.PER_ASG_BUS2 dependencies on PER_SECONDARY_ASS_STATUSES

Line 3084: -- - PER_SECONDARY_ASS_STATUSES

3080: -- - PER_COBRA_COV_ENROLLMENTS
3081: -- - PER_COBRA_COVERAGE_BENEFITS_F
3082: -- - PER_ASSIGNMENTS_EXTRA_INFO
3083: -- - HR_ASSIGNMENT_SET_AMENDMENTS
3084: -- - PER_SECONDARY_ASS_STATUSES
3085: --
3086: -- Pre-conditions:
3087: -- None
3088: --

Line 3178: from per_secondary_ass_statuses

3174: cursor csr_per_secondary_ass_stat is
3175: select null
3176: from sys.dual
3177: where exists(select null
3178: from per_secondary_ass_statuses
3179: where assignment_id = p_assignment_id
3180: and (p_datetrack_mode = 'ZAP'
3181: or (p_datetrack_mode = 'DELETE'
3182: and start_date > p_validation_start_date)));

Line 3303: -- assignment on per_secondary_ass_statuses when

3299: --
3300: hr_utility.set_location(l_proc, 6);
3301: --
3302: -- Check that no child records exist for the
3303: -- assignment on per_secondary_ass_statuses when
3304: -- the assignment is deleted
3305: --
3306: open csr_per_secondary_ass_stat;
3307: fetch csr_per_secondary_ass_stat into l_exists;