APPS.PER_ASG_BUS2 dependencies on PER_SECONDARY_ASS_STATUSES

Line 3124: -- - PER_SECONDARY_ASS_STATUSES

3120: -- - PER_COBRA_COV_ENROLLMENTS
3121: -- - PER_COBRA_COVERAGE_BENEFITS_F
3122: -- - PER_ASSIGNMENTS_EXTRA_INFO
3123: -- - HR_ASSIGNMENT_SET_AMENDMENTS
3124: -- - PER_SECONDARY_ASS_STATUSES
3125: --
3126: -- Pre-conditions:
3127: -- None
3128: --

Line 3218: from per_secondary_ass_statuses

3214: cursor csr_per_secondary_ass_stat is
3215: select null
3216: from sys.dual
3217: where exists(select null
3218: from per_secondary_ass_statuses
3219: where assignment_id = p_assignment_id
3220: and (p_datetrack_mode = 'ZAP'
3221: or (p_datetrack_mode = 'DELETE'
3222: and start_date > p_validation_start_date)));

Line 3343: -- assignment on per_secondary_ass_statuses when

3339: --
3340: hr_utility.set_location(l_proc, 6);
3341: --
3342: -- Check that no child records exist for the
3343: -- assignment on per_secondary_ass_statuses when
3344: -- the assignment is deleted
3345: --
3346: open csr_per_secondary_ass_stat;
3347: fetch csr_per_secondary_ass_stat into l_exists;