[Home] [Help]
151: ,job_name per_jobs.name%type
152: ,payroll_name pay_all_payrolls_f.payroll_name%type
153: ,organization_name hr_all_organization_units.name%type
154: ,location_code hr_locations_all.location_code%type
155: ,pay_basis_name per_pay_bases.name%type
156: );
157:
158: g_wstr_names t_asg_wrk_strs;
159:
442: cursor csr_paybasis(c_pay_basis_id in number
443: ,c_business_group_id in number
444: ) is
445: select ppb.name
446: from per_pay_bases ppb
447: where ppb.pay_basis_id = c_pay_basis_id
448: and ppb.business_group_id = c_business_group_id;
449: --
450: -- Cursor to check if address already exists
1907: -- for work structures like grade, job, organization etc.
1908: -- =============================================================================
1909: procedure Get_WrkStrs_Names is
1910: l_proc_name constant varchar2(150):= g_pkg ||'Get_WrkStrs_Names';
1911: l_pay_basis_name per_pay_bases.name%type;
1912: l_organization_name hr_all_organization_units.name%type;
1913: l_location_code hr_locations_all.location_code%type;
1914: l_payroll_name pay_all_payrolls_f.payroll_name%type;
1915: l_job_name per_jobs.name%type;
7870: l_dp_mode varchar2(40);
7871: l_if_end_dated varchar2(20);
7872: l_api_name hr_api_modules.module_name%type;
7873: l_user_person_type per_person_types.user_person_type%type;
7874: l_pay_basis_name per_pay_bases.name%type;
7875: l_organization_name hr_all_organization_units.name%type;
7876: l_location_code hr_locations_all.location_code%type;
7877: l_payroll_name pay_payrolls_f.payroll_name%type;
7878: l_job_name per_jobs.name%type;