DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 181: ,per_assignment_status_types type

177: ,nvl(x_job_id, per.job_id)
178: into x_organization_id
179: ,x_job_id
180: from per_assignments_f per
181: ,per_assignment_status_types type
182: where trunc(p_txn_date) between trunc(effective_start_date) and trunc(nvl(effective_end_date,p_txn_date))
183: and per.person_id = p_person_id
184: and per.primary_flag = 'Y'
185: and per.assignment_type in ('E', 'C')