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 411: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type

407: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
408: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
409: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
410: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
411: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
412: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
413: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
414: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
415: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type

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

408: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
409: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
410: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
411: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
412: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
413: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
414: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
415: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
416: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type

Line 443: l_salary_basis per_pay_bases.name%type;

439: l_grade_id per_all_assignments_f.grade_id%type;
440: l_frequency_meaning hr_lookups.meaning%type;
441: l_location hr_locations.location_code%type;
442: l_probation_unit_meaning hr_lookups.meaning%type;
443: l_salary_basis per_pay_bases.name%type;
444: l_pay_basis per_pay_bases.pay_basis%type;
445: l_payroll pay_all_payrolls_f.payroll_name%type;
446: l_supervisor per_all_people_f.full_name%type;
447: l_bargaining_unit hr_all_positions_f.bargaining_unit_cd%type;

Line 444: l_pay_basis per_pay_bases.pay_basis%type;

440: l_frequency_meaning hr_lookups.meaning%type;
441: l_location hr_locations.location_code%type;
442: l_probation_unit_meaning hr_lookups.meaning%type;
443: l_salary_basis per_pay_bases.name%type;
444: l_pay_basis per_pay_bases.pay_basis%type;
445: l_payroll pay_all_payrolls_f.payroll_name%type;
446: l_supervisor per_all_people_f.full_name%type;
447: l_bargaining_unit hr_all_positions_f.bargaining_unit_cd%type;
448: l_dummy number;

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

649: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
650: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
651: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
652: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
653: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
654: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
655: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
656: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
657: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type

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

650: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
651: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
652: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
653: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
654: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
655: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
656: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
657: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
658: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type

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

849: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
850: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
851: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
852: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
853: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
854: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
855: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
856: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
857: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type

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

850: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
851: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
852: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
853: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
854: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
855: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
856: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
857: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
858: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type