APPS.HR_DELETE dependencies on PER_BUSINESS_GROUPS

Line 392: l_business_group_name per_business_groups.name%type ;

388: --
389: PROCEDURE delete_bal_load_struct(p_business_group_id NUMBER)
390: IS
391: --
392: l_business_group_name per_business_groups.name%type ;
393: --
394: CURSOR get_bg IS
395: SELECT bg.name
396: FROM per_business_groups bg

Line 396: FROM per_business_groups bg

392: l_business_group_name per_business_groups.name%type ;
393: --
394: CURSOR get_bg IS
395: SELECT bg.name
396: FROM per_business_groups bg
397: WHERE bg.business_group_id = p_business_group_id ;
398: --
399: CURSOR pbh IS
400: SELECT bh.batch_id,

Line 1968: l_security_group_id per_business_groups.security_group_id%TYPE;

1964: l_exists varchar2(1);
1965: --
1966: l_organization_id hr_organization_units.organization_id%TYPE;
1967: --
1968: l_security_group_id per_business_groups.security_group_id%TYPE;
1969: --
1970: cursor csr_get_ost
1971: (c_business_group_id
1972: PER_ORGANIZATION_STRUCTURES.business_group_id%TYPE)

Line 1990: from per_business_groups

1986: if p_rt_running = 'N' then
1987: --
1988: select security_group_id
1989: into l_security_group_id
1990: from per_business_groups
1991: where business_group_id = p_business_group_id;
1992: --
1993: hr_utility.set_location('Entering: '||l_proc, 13);
1994: --