DBA Data[Home] [Help]

APPS.IRC_PARTY_PERSON_UTL dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 63: from per_establishment_attendances

59: where party_id is not null
60: and person_id is null
61: union
62: select party_id,person_id
63: from per_establishment_attendances
64: where party_id is not null
65: and person_id is null
66: union
67: select party_id,person_id

Line 511: update per_establishment_attendances

507: --
508: -- update the establishment attendance records directly for performance
509: --
510:
511: update per_establishment_attendances
512: set person_id=l_person_ids(i)
513: ,business_group_id=l_business_group_id
514: where party_id=l_party_ids(i)
515: and person_id is null;