DBA Data[Home] [Help]

APPS.PER_SHA_BUS dependencies on PER_BUSINESS_GROUPS

Line 358: per_business_groups bus

354: CURSOR csr_valid_actual_date_taken IS
355: SELECT NVL(sth.standard_holiday_id,99)
356: FROM per_standard_holidays sth,
357: per_people_f per,
358: per_business_groups bus
359: WHERE per.person_id = p_person_id
360: AND p_actual_date_taken BETWEEN per.effective_start_date
361: AND per.effective_end_date
362: AND bus.business_group_id = per.business_group_id

Line 776: from per_business_groups pbg

772: -- Declare cursor
773: --
774: cursor csr_leg_code is
775: select pbg.legislation_code
776: from per_business_groups pbg
777: , per_people_f per
778: , per_std_holiday_absences sha
779: where sha.std_holiday_absences_id = p_std_holiday_absences_id
780: and per.person_id = sha.person_id