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 1273: update PER_ESTABLISHMENT_ATTENDANCES

1269: raise;
1270: end;
1271:
1272: begin
1273: update PER_ESTABLISHMENT_ATTENDANCES
1274: set party_id = null
1275: where party_id = p_party_id;
1276: exception
1277: when no_data_found then

Line 1398: from per_establishment_attendances esta,

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

Line 1599: update per_establishment_attendances

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

Line 1722: update PER_ESTABLISHMENT_ATTENDANCES

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

Line 6243: update per_establishment_attendances

6239: --
6240: -- Bulk update etablishment attendances records
6241: --
6242: forall i in t_elig_person_id.first..t_elig_person_id.last
6243: update per_establishment_attendances
6244: set party_id = t_party_id(i)
6245: where person_id = t_elig_person_id(i);
6246: --
6247: -- Bulk update previous employment records