[Home] [Help]
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , hr_de_soc_ins_contr_lvls_f cle
30: , hr_organization_units hou
31: where cle.soc_ins_contr_lvls_id = p_soc_ins_contr_lvls_id
32: and pbg.business_group_id = hou.business_group_id
33: and hou.organization_id = cle.organization_id;
34: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , hr_de_soc_ins_contr_lvls_f cle
95: , hr_organization_units hou
96: where cle.soc_ins_contr_lvls_id = p_soc_ins_contr_lvls_id
97: and cle.organization_id = hou.organization_id
98: and pbg.business_group_id = hou.business_group_id;
99:
407: -- {Start Of Comments}
408: --
409: -- Description:
410: -- This procedure is used to ensure that organization_id is a foriegn key
411: -- to hr_organization_units and it is unique for given start and end date
412: -- Organization Classifictaion for given organization shold be Mandatory
413: -- Health Provider
414: -- Pre Conditions:
415: -- g_old_rec has been populated with details of the values currently in
440: ) IS
441:
442: CURSOR csr_chk_organization_id1 IS
443: SELECT 'Y'
444: FROM hr_organization_units hou
445: WHERE hou.organization_id = p_organization_id
446: and p_validation_start_date between hou.date_from and nvl(hou.date_to,p_validation_end_date);
447:
448: CURSOR csr_chk_organization_id2 IS
446: and p_validation_start_date between hou.date_from and nvl(hou.date_to,p_validation_end_date);
447:
448: CURSOR csr_chk_organization_id2 IS
449: SELECT 'Y'
450: FROM hr_organization_units hou
451: WHERE hou.organization_id = p_organization_id
452: and p_validation_end_date between hou.date_from and nvl(hou.date_to,p_validation_end_date);
453:
454: CURSOR csr_chk_organization_id3 IS