DBA Data[Home] [Help]

APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 725: per_assignment_status_types ast

721: abv.effective_end_date)
722: AND abv.assignment_id =
723: (select assignment_id
724: from per_all_assignments_f asg,
725: per_assignment_status_types ast
726: where asg.assignment_id = p_assignment_id
727: AND asg.assignment_type = 'E'
728: AND (p_period_end_dt BETWEEN asg.effective_start_date AND
729: asg.effective_end_date)