DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PER_ASSIGNMENTS_F

Line 180: from per_assignments_f per

176: select nvl(x_organization_id, per.organization_id)
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'