DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PER_ASSIGNMENTS_F

Line 164: from per_assignments_f per

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