DBA Data[Home] [Help]

APPS.PER_QH_POPULATE dependencies on PER_PAY_BASES

Line 145: l_salary_basis_name per_pay_bases.name%type;

141: ,p_pay_basis_meaning OUT NOCOPY VARCHAR2
142: ,p_salary_basis OUT NOCOPY VARCHAR2) is
143: --
144: l_proc varchar2(72) :=g_package||'get_salary_basis';
145: l_salary_basis_name per_pay_bases.name%type;
146: --
147: cursor csr_salary_basis is
148: select ppb.name
149: , ppb.pay_basis

Line 150: from per_pay_bases ppb

146: --
147: cursor csr_salary_basis is
148: select ppb.name
149: , ppb.pay_basis
150: from per_pay_bases ppb
151: where ppb.pay_basis_id=p_pay_basis_id;
152: begin
153: --
154: hr_utility.set_location('Entering: '||l_proc,10);

Line 404: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type

400: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
401: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
402: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
403: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
404: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
405: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
406: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
407: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
408: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type

Line 405: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type

401: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
402: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
403: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
404: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
405: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
406: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
407: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
408: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
409: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type

Line 436: l_salary_basis per_pay_bases.name%type;

432: l_grade_id per_all_assignments_f.grade_id%type;
433: l_frequency_meaning hr_lookups.meaning%type;
434: l_location hr_locations.location_code%type;
435: l_probation_unit_meaning hr_lookups.meaning%type;
436: l_salary_basis per_pay_bases.name%type;
437: l_pay_basis per_pay_bases.pay_basis%type;
438: l_payroll pay_all_payrolls_f.payroll_name%type;
439: l_supervisor per_all_people_f.full_name%type;
440: l_bargaining_unit hr_all_positions_f.bargaining_unit_cd%type;

Line 437: l_pay_basis per_pay_bases.pay_basis%type;

433: l_frequency_meaning hr_lookups.meaning%type;
434: l_location hr_locations.location_code%type;
435: l_probation_unit_meaning hr_lookups.meaning%type;
436: l_salary_basis per_pay_bases.name%type;
437: l_pay_basis per_pay_bases.pay_basis%type;
438: l_payroll pay_all_payrolls_f.payroll_name%type;
439: l_supervisor per_all_people_f.full_name%type;
440: l_bargaining_unit hr_all_positions_f.bargaining_unit_cd%type;
441: l_dummy number;

Line 646: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type

642: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
643: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
644: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
645: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
646: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
647: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
648: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
649: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
650: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type

Line 647: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type

643: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
644: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
645: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
646: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
647: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
648: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
649: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
650: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
651: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type

Line 846: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type

842: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
843: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
844: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
845: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
846: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
847: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
848: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
849: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
850: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type

Line 847: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type

843: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
844: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
845: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
846: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
847: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
848: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
849: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
850: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
851: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type