APPS.HR_PDT_BUS dependencies on PAY_PEOPLE_GROUPS

Line 3503: -- This procedures validates that people group id exists on pay_people_groups

3499: -- |------------------------< chk_people_group_id >--------------------------|
3500: -- ---------------------------------------------------------------------------
3501: --
3502: -- Desciption:
3503: -- This procedures validates that people group id exists on pay_people_groups
3504: -- and that the structure of the provided combination is valid for the Host BG
3505: --
3506: -- Pre-conditions :
3507: -- None

Line 3537: l_id_flex_num pay_people_groups.id_flex_num%type;

3533: ) is
3534: --
3535: l_proc varchar2(72) := g_package||'chk_people_group_id';
3536: l_api_updating boolean;
3537: l_id_flex_num pay_people_groups.id_flex_num%type;
3538: l_enabled_flag pay_people_groups.enabled_flag%TYPE;
3539: l_bg_id_flex_num per_business_groups_perf.people_group_structure%type;
3540: --
3541: cursor csr_check_grp is

Line 3538: l_enabled_flag pay_people_groups.enabled_flag%TYPE;

3534: --
3535: l_proc varchar2(72) := g_package||'chk_people_group_id';
3536: l_api_updating boolean;
3537: l_id_flex_num pay_people_groups.id_flex_num%type;
3538: l_enabled_flag pay_people_groups.enabled_flag%TYPE;
3539: l_bg_id_flex_num per_business_groups_perf.people_group_structure%type;
3540: --
3541: cursor csr_check_grp is
3542: select enabled_flag,id_flex_num

Line 3543: from pay_people_groups

3539: l_bg_id_flex_num per_business_groups_perf.people_group_structure%type;
3540: --
3541: cursor csr_check_grp is
3542: select enabled_flag,id_flex_num
3543: from pay_people_groups
3544: where people_group_id = p_people_group_id
3545: and p_start_date between
3546: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
3547: --