DBA Data[Home] [Help]

APPS.OE_BULK_CACHE dependencies on PER_ALL_ASSIGNMENTS_F

Line 2258: FROM PER_ALL_ASSIGNMENTS_F ASGN,

2254: INTO G_PERSON_TBL(p_key).organization_id,
2255: G_PERSON_TBL(p_key).location_id,
2256: G_PERSON_TBL(p_key).start_date,
2257: G_PERSON_TBL(p_key).end_date
2258: FROM PER_ALL_ASSIGNMENTS_F ASGN,
2259: hr_organization_units hou
2260: WHERE ASGN.PERSON_ID = p_key
2261: AND NVL(ASGN.PRIMARY_FLAG, 'Y') = 'Y'
2262: AND hou.organization_id = ASGN.ORGANIZATION_ID