[Home] [Help]
150: ,job_name per_jobs.name%type
151: ,payroll_name pay_all_payrolls_f.payroll_name%type
152: ,organization_name hr_all_organization_units.name%type
153: ,location_code hr_locations_all.location_code%type
154: ,pay_basis_name per_pay_bases.name%type
155: );
156:
157: g_wstr_names t_asg_wrk_strs;
158:
441: cursor csr_paybasis(c_pay_basis_id in number
442: ,c_business_group_id in number
443: ) is
444: select ppb.name
445: from per_pay_bases ppb
446: where ppb.pay_basis_id = c_pay_basis_id
447: and ppb.business_group_id = c_business_group_id;
448: --
449: -- Cursor to check if address already exists
1805: -- for work structures like grade, job, organization etc.
1806: -- =============================================================================
1807: procedure Get_WrkStrs_Names is
1808: l_proc_name constant varchar2(150):= g_pkg ||'Get_WrkStrs_Names';
1809: l_pay_basis_name per_pay_bases.name%type;
1810: l_organization_name hr_all_organization_units.name%type;
1811: l_location_code hr_locations_all.location_code%type;
1812: l_payroll_name pay_all_payrolls_f.payroll_name%type;
1813: l_job_name per_jobs.name%type;
7466: l_dp_mode varchar2(40);
7467: l_if_end_dated varchar2(20);
7468: l_api_name hr_api_modules.module_name%type;
7469: l_user_person_type per_person_types.user_person_type%type;
7470: l_pay_basis_name per_pay_bases.name%type;
7471: l_organization_name hr_all_organization_units.name%type;
7472: l_location_code hr_locations_all.location_code%type;
7473: l_payroll_name pay_payrolls_f.payroll_name%type;
7474: l_job_name per_jobs.name%type;