APPS.HR_PDT_BUS dependencies on PAY_PEOPLE_GROUPS

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

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

Line 3538: l_id_flex_num pay_people_groups.id_flex_num%type;

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

Line 3539: l_enabled_flag pay_people_groups.enabled_flag%TYPE;

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

Line 3544: from pay_people_groups

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