APPS.PER_QUA_BUS dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 297: -- and the attendance_id must exist in the per_establishment_attendances table.

293: --
294: -- Description
295: -- This procedure checks that a person_id or attendance_id are populated.
296: -- The person_id must exist in the per_people_f table as of the effective date
297: -- and the attendance_id must exist in the per_establishment_attendances table.
298: --
299: -- Pre-Conditions
300: -- None.
301: --

Line 342: from per_establishment_attendances per

338: and nvl(per.effective_end_date,hr_api.g_eot);
339: --
340: cursor c2 is
341: select null
342: from per_establishment_attendances per
343: where per.attendance_id = p_attendance_id;
344: --
345: Begin
346: --

Line 380: -- attendance_id must exist in PER_ESTABLISHMENT_ATTENDANCES table.

376: end if;
377: --
378: -- Check that values exist in the relevant tables.
379: -- person_id must exist in PER_PEOPLE_F as of the effective date.
380: -- attendance_id must exist in PER_ESTABLISHMENT_ATTENDANCES table.
381: --
382: if p_person_id is not null then
383: --
384: open c1;

Line 475: l_person_id per_establishment_attendances.person_id%TYPE;

471: --
472: l_proc varchar2(72) := g_package||'chk_party_id';
473: l_party_id per_qualifications.party_id%TYPE;
474: l_party_id2 per_qualifications.party_id%TYPE;
475: l_person_id per_establishment_attendances.person_id%TYPE;
476: --
477: --
478: -- cursor to check that the party_id maches person_id
479: --

Line 496: from per_establishment_attendances pea

492: --
493: cursor csr_attendances is
494: select party_id
495: ,person_id
496: from per_establishment_attendances pea
497: where pea.attendance_id = p_rec.attendance_id;
498: --
499: begin
500: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 550: -- derive party_id from per_establishment_attendances

546: );
547: end if;
548: else
549: --
550: -- derive party_id from per_establishment_attendances
551: --
552: hr_utility.set_location(l_proc,80);
553: -- p_rec.person_id := l_person_id; WWBUG#2289195
554: p_rec.party_id := l_party_id;

Line 1026: from per_establishment_attendances per

1022: -- within the related establishment attendance
1023: --
1024: cursor c1 is
1025: select null
1026: from per_establishment_attendances per
1027: where per.attendance_id = p_attendance_id
1028: and nvl(p_start_date,nvl(per.attended_start_date,hr_api.g_sot))
1029: between nvl(per.attended_start_date,hr_api.g_sot)
1030: and nvl(per.attended_end_date,hr_api.g_eot)

Line 1474: from per_establishment_attendances per

1470: l_dummy varchar2(1);
1471: --
1472: cursor c1 is
1473: select null
1474: from per_establishment_attendances per
1475: where per.attendance_id = p_attendance_id
1476: and nvl(per.business_group_id,-1) = nvl(p_business_group_id,
1477: nvl(per.business_group_id,-1));
1478: --