DBA Data[Home] [Help]

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')