APPS.OTA_TMT_BUS dependencies on PER_BUSINESS_GROUPS

Line 90: from per_business_groups pbg

86: -- Declare cursor
87: --
88: cursor csr_leg_code is
89: select pbg.legislation_code
90: from per_business_groups pbg
91: , ota_tp_measurement_types tmt
92: where tmt.tp_measurement_type_id = p_tp_measurement_type_id
93: and pbg.business_group_id = tmt.business_group_id;
94: --

Line 419: from per_business_groups pbg

415: ) is
416: --
417: cursor csr_leg_code is
418: select pbg.legislation_code
419: from per_business_groups pbg
420: where pbg.business_group_id = p_rec.business_group_id;
421: l_proc varchar2(72) := g_package||'insert_validate';
422: l_legislation_code per_business_groups.legislation_code%TYPE;
423: --

Line 422: l_legislation_code per_business_groups.legislation_code%TYPE;

418: select pbg.legislation_code
419: from per_business_groups pbg
420: where pbg.business_group_id = p_rec.business_group_id;
421: l_proc varchar2(72) := g_package||'insert_validate';
422: l_legislation_code per_business_groups.legislation_code%TYPE;
423: --
424: Begin
425: hr_utility.set_location('Entering:'||l_proc, 5);
426: --

Line 510: from per_business_groups pbg

506: ) is
507: --
508: cursor csr_leg_code is
509: select pbg.legislation_code
510: from per_business_groups pbg
511: where pbg.business_group_id = p_rec.business_group_id;
512: l_legislation_code per_business_groups.legislation_code%TYPE;
513: l_proc varchar2(72) := g_package||'update_validate';
514: --

Line 512: l_legislation_code per_business_groups.legislation_code%TYPE;

508: cursor csr_leg_code is
509: select pbg.legislation_code
510: from per_business_groups pbg
511: where pbg.business_group_id = p_rec.business_group_id;
512: l_legislation_code per_business_groups.legislation_code%TYPE;
513: l_proc varchar2(72) := g_package||'update_validate';
514: --
515: Begin
516: hr_utility.set_location('Entering:'||l_proc, 5);