APPS.PER_ASG_BUS3 dependencies on PER_PERIODS_OF_PLACEMENT

Line 412: -- PER_PERIODS_OF_PLACEMENTS between the period of service date start

408: -- - Validates that the assignment is an non payrolled worker assignment.
409: -- - Validates that the period of placement date start is set for
410: -- an NPW assignment.
411: -- - Validates that the period of placement date start exists in
412: -- PER_PERIODS_OF_PLACEMENTS between the period of service date start
413: -- and actual termination date and for the person id.
414: -- - Validates that the business_group_id of the Assignment is the same as
415: -- that of the period of placement.
416: -- - Validates that the effective start date of the assignment is between

Line 450: -- - period of placement does'nt exist in PER_PERIODS_OF_PLACEMENT between

446: -- Post Failure:
447: -- An application error is raised and processing ends if:
448: -- - the assignment is not an NPW assignment.
449: -- - period of placement is not set for a NPW assignment.
450: -- - period of placement does'nt exist in PER_PERIODS_OF_PLACEMENT between
451: -- date start and actual termination date and for the person_id
452: -- - the period of placement is in a different business group to
453: -- the assignment business group.
454: -- - the effective start date of the assignment is not between date

Line 465: ,p_pop_date_start IN per_periods_of_placement.date_start%TYPE

461: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
462: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
463: ,p_person_id IN per_all_assignments_f.person_id%TYPE
464: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
465: ,p_pop_date_start IN per_periods_of_placement.date_start%TYPE
466: ,p_validation_start_date IN DATE
467: ,p_validation_end_date IN DATE
468: ,p_effective_date IN DATE
469: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE