APPS.PQP_HROSS_INTEGRATION dependencies on PER_PAY_BASES

Line 376: FROM per_pay_bases ppb

372: CURSOR csr_paybasis(c_pay_basis_id IN Number
373: ,c_business_group_id IN Number
374: ) IS
375: SELECT ppb.NAME
376: FROM per_pay_bases ppb
377: WHERE ppb.pay_basis_id = c_pay_basis_id
378: AND ppb.business_group_id = c_business_group_id;
379:
380: -- Cursor to check if address already exists

Line 2739: l_pay_basis_name per_pay_bases.NAME%TYPE;

2735: l_cont_object_version_num
2736: per_contact_relationships.object_version_number%TYPE;
2737: l_cur_add_rec per_addresses%ROWTYPE;
2738: l_cont_rec per_contact_relationships%ROWTYPE;
2739: l_pay_basis_name per_pay_bases.NAME%TYPE;
2740: l_organization_name hr_all_organization_units.NAME%TYPE;
2741: l_location_code hr_locations_all.location_code%TYPE;
2742: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
2743: l_job_name per_jobs.NAME%TYPE;

Line 3931: l_pay_basis_name per_pay_bases.NAME%TYPE;

3927: l_dp_mode Varchar2(10);
3928: l_if_end_dated Varchar2(20);
3929: l_api_name hr_api_modules.module_name%TYPE;
3930: l_user_person_type per_person_types.user_person_type%TYPE;
3931: l_pay_basis_name per_pay_bases.NAME%TYPE;
3932: l_organization_name hr_all_organization_units.NAME%TYPE;
3933: l_location_code hr_locations_all.location_code%TYPE;
3934: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
3935: l_job_name per_jobs.NAME%TYPE;