APPS.PA_COST_RATE_PUB dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 165: ,per_assignment_status_types type
161: ,nvl(x_job_id, per.job_id)
162: into x_organization_id
163: ,x_job_id
164: from per_assignments_f per 165: ,per_assignment_status_types type 166: where trunc(p_txn_date) between trunc(effective_start_date) and trunc(nvl(effective_end_date,p_txn_date))
167: and per.person_id = p_person_id
168: and per.primary_flag = 'Y'
169: and per.assignment_type in ('E', 'C')