DBA Data[Home] [Help]

APPS.PA_MISC dependencies on PER_ASSIGNMENTS_F

Line 109: per_assignments_f asn

105:
106: SELECT job_id
107: INTO x_job_id
108: FROM pa_implementations imp,
109: per_assignments_f asn
110: WHERE x_person_id = asn.person_id
111: AND asn.primary_flag = 'Y'
112: AND asn.business_group_id+0 = imp.business_group_id
113: AND x_effective_date BETWEEN asn.effective_start_date