APPS.HR_DELETE dependencies on PER_POSITION_STRUCTURES

Line 790: PER_POSITION_STRUCTURES.business_group_id%TYPE)

786: WHERE business_group_id = c_business_group_id);
787: --
788: cursor csr_get_pst
789: (c_business_group_id
790: PER_POSITION_STRUCTURES.business_group_id%TYPE)
791: is
792: SELECT null
793: FROM sys.dual
794: WHERE exists(select null

Line 795: FROM PER_POSITION_STRUCTURES

791: is
792: SELECT null
793: FROM sys.dual
794: WHERE exists(select null
795: FROM PER_POSITION_STRUCTURES
796: WHERE business_group_id = c_business_group_id);
797: --
798: cursor csr_get_evt
799: (c_business_group_id

Line 1170: PER_POSITION_STRUCTURES.business_group_id%TYPE)

1166: l_exists varchar2(1);
1167: --
1168: cursor csr_get_pst
1169: (c_business_group_id
1170: PER_POSITION_STRUCTURES.business_group_id%TYPE)
1171: is
1172: SELECT null
1173: FROM PER_POSITION_STRUCTURES
1174: WHERE business_group_id = c_business_group_id;

Line 1173: FROM PER_POSITION_STRUCTURES

1169: (c_business_group_id
1170: PER_POSITION_STRUCTURES.business_group_id%TYPE)
1171: is
1172: SELECT null
1173: FROM PER_POSITION_STRUCTURES
1174: WHERE business_group_id = c_business_group_id;
1175: --
1176: cursor csr_get_job
1177: (c_business_group_id per_jobs.business_group_id%TYPE)

Line 1201: DELETE FROM per_position_structures ps

1197: DELETE FROM per_pos_structure_versions psv
1198: WHERE psv.business_group_id = p_business_group_id;
1199: hr_utility.set_location(l_proc,30);
1200: --
1201: DELETE FROM per_position_structures ps
1202: WHERE ps.business_group_id = p_business_group_id;
1203: hr_utility.set_location(l_proc,40);
1204: --
1205: end if;