APPS.PER_HRTCA_MERGE dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 107: from per_establishment_attendances

103: l_qualifications c_qualifications%rowtype;
104: --
105: cursor c_establishment_attendances is
106: select *
107: from per_establishment_attendances
108: where person_id = p_rec.person_id;
109: --
110: cursor c_qualifications_estab is
111: select qua.*

Line 113: per_establishment_attendances esa

109: --
110: cursor c_qualifications_estab is
111: select qua.*
112: from per_qualifications qua,
113: per_establishment_attendances esa
114: where esa.attendance_id = qua.attendance_id
115: and esa.person_id = p_rec.person_id;
116: --
117: l_establishment_attendances c_establishment_attendances%rowtype;

Line 295: update per_establishment_attendances

291: exit when c_establishment_attendances%notfound;
292: --
293: -- No API at the moment so use base table.
294: --
295: update per_establishment_attendances
296: set party_id = p_rec.party_id
297: where attendance_id = l_establishment_attendances.attendance_id;
298: --
299: end loop;

Line 1270: update PER_ESTABLISHMENT_ATTENDANCES

1266: raise;
1267: end;
1268:
1269: begin
1270: update PER_ESTABLISHMENT_ATTENDANCES
1271: set party_id = null
1272: where party_id = p_party_id;
1273: exception
1274: when no_data_found then

Line 1395: from per_establishment_attendances esta,

1391: t_qua_party_id g_party_id_type;
1392: --
1393: cursor c_establishment_attendances is
1394: select esta.party_id
1395: from per_establishment_attendances esta,
1396: hr_tca_party_unmerge punm
1397: where esta.party_id = punm.party_id
1398: and punm.status = 'PURGE';
1399: --

Line 1596: update per_establishment_attendances

1592: --
1593: -- No API at the moment so use base table.
1594: --
1595: forall i in t_esta_party_id.first..t_esta_party_id.last
1596: update per_establishment_attendances
1597: set party_id = null
1598: where party_id = t_esta_party_id(i);
1599: --
1600: commit;

Line 1719: update PER_ESTABLISHMENT_ATTENDANCES

1715: raise;
1716: end;
1717:
1718: begin
1719: update PER_ESTABLISHMENT_ATTENDANCES
1720: set party_id = p_party_id
1721: where person_id = p_person_id;
1722: exception
1723: when no_data_found then

Line 6223: update per_establishment_attendances

6219: --
6220: -- Bulk update etablishment attendances records
6221: --
6222: forall i in t_elig_person_id.first..t_elig_person_id.last
6223: update per_establishment_attendances
6224: set party_id = t_party_id(i)
6225: where person_id = t_elig_person_id(i);
6226: --
6227: -- Bulk update previous employment records