APPS.PER_ASG_BUS2 dependencies on PAY_PEOPLE_GROUPS

Line 813: l_enabled_flag pay_people_groups.enabled_flag%TYPE;

809: l_exists varchar2(1);
810: l_api_updating boolean;
811: l_proc varchar2(72) := g_package||'chk_people_group_id';
812: l_vac_people_group_id per_all_assignments_f.people_group_id%TYPE;
813: l_enabled_flag pay_people_groups.enabled_flag%TYPE;
814: --
815: cursor csr_valid_people_group is
816: select enabled_flag
817: from pay_people_groups

Line 817: from pay_people_groups

813: l_enabled_flag pay_people_groups.enabled_flag%TYPE;
814: --
815: cursor csr_valid_people_group is
816: select enabled_flag
817: from pay_people_groups
818: where people_group_id = p_people_group_id
819: and p_validation_start_date
820: between nvl(start_date_active,hr_api.g_sot)
821: and nvl(end_date_active,hr_api.g_eot);

Line 826: ,pay_people_groups ppg

822: --
823: cursor csr_valid_id_flex_num is
824: select null
825: from per_business_groups_perf pbg
826: ,pay_people_groups ppg
827: where ppg.people_group_id = p_people_group_id
828: and pbg.people_group_structure = to_char(ppg.id_flex_num)
829: and pbg.business_group_id = p_business_group_id;
830: --