DBA Data[Home] [Help]

APPS.HXT_BATCH_VAL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 505: per_assignment_status_types past

501: /* Hints supplied to always force the correct execution plan */
502: paf.assignment_id
503: FROM
504: per_assignments_f paf,
505: per_assignment_status_types past
506: WHERE
507: paf.person_id = p_person_id AND
508: p_effective_date BETWEEN
509: paf.effective_start_date AND paf.effective_end_date AND

Line 898: per_assignment_status_types past

894: /* Hints supplied to always force the correct execution plan */
895: 1
896: FROM
897: per_assignments_f paf,
898: per_assignment_status_types past
899: WHERE
900: paf.assignment_id = p_asg_id AND
901: p_effective_date BETWEEN
902: paf.effective_start_date AND paf.effective_end_date