APPS.PER_ASG_BUS2 dependencies on PAY_PEOPLE_GROUPS

Line 853: l_enabled_flag pay_people_groups.enabled_flag%TYPE;

849: l_exists varchar2(1);
850: l_api_updating boolean;
851: l_proc varchar2(72) := g_package||'chk_people_group_id';
852: l_vac_people_group_id per_all_assignments_f.people_group_id%TYPE;
853: l_enabled_flag pay_people_groups.enabled_flag%TYPE;
854: --
855: cursor csr_valid_people_group is
856: select enabled_flag
857: from pay_people_groups

Line 857: from pay_people_groups

853: l_enabled_flag pay_people_groups.enabled_flag%TYPE;
854: --
855: cursor csr_valid_people_group is
856: select enabled_flag
857: from pay_people_groups
858: where people_group_id = p_people_group_id
859: and p_validation_start_date
860: between nvl(start_date_active,hr_api.g_sot)
861: and nvl(end_date_active,hr_api.g_eot);

Line 866: ,pay_people_groups ppg

862: --
863: cursor csr_valid_id_flex_num is
864: select null
865: from per_business_groups_perf pbg
866: ,pay_people_groups ppg
867: where ppg.people_group_id = p_people_group_id
868: and pbg.people_group_structure = to_char(ppg.id_flex_num)
869: and pbg.business_group_id = p_business_group_id;
870: --