APPS.PER_SSM_BUS dependencies on PER_BUSINESS_GROUPS

Line 25: from per_business_groups pbg,

21: -- Cursor to find legislation code
22: --
23: cursor csr_leg_code is
24: select pbg.legislation_code
25: from per_business_groups pbg,
26: per_salary_survey_mappings ssm
27: where ssm.salary_survey_mapping_id = p_salary_survey_mapping_id
28: and pbg.business_group_id = ssm.business_group_id;
29: --

Line 364: l_business_group_id per_business_groups.business_group_id%TYPE;

360: p_ssl_end_date in date) is
361: --
362: l_proc varchar2(72) := g_package||'chk_parent';
363: l_api_updating boolean;
364: l_business_group_id per_business_groups.business_group_id%TYPE;
365: l_parent_start_date date;
366: l_parent_end_date date;
367: --
368: cursor csr_chk_job_id_exists is