DBA Data[Home] [Help]

APPS.PER_QH_POPULATE dependencies on HR_LOOKUPS

Line 316: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

312: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
313: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
314: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
315: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
316: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
317: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
318: ,p_location OUT NOCOPY hr_locations.location_code%type
319: ,p_gre OUT NOCOPY hr_soft_coding_keyflex.segment1%type
320: ) is

Line 404: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

400: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
401: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
402: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
403: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
404: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
405: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
406: ,p_location OUT NOCOPY hr_locations.location_code%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

Line 409: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type

405: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
406: ,p_location OUT NOCOPY hr_locations.location_code%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

Line 413: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%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
417: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type

Line 421: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type

417: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
418: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
419: ,p_grade OUT NOCOPY per_grades.name%type
420: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
421: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
422: ) is
423: --
424: l_proc varchar2(72) :=g_package||'get_pos_defaults';
425: l_position_id per_all_assignments_f.position_id%type;

Line 440: l_frequency_meaning hr_lookups.meaning%type;

436: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
437: l_payroll_id per_all_assignments_f.payroll_id%type;
438: l_supervisor_id per_all_assignments_f.supervisor_id%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;

Line 442: l_probation_unit_meaning hr_lookups.meaning%type;

438: l_supervisor_id per_all_assignments_f.supervisor_id%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;

Line 646: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

642: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
643: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
644: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
645: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
646: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
647: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
648: ,p_location OUT NOCOPY hr_locations.location_code%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

Line 651: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type

647: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
648: ,p_location OUT NOCOPY hr_locations.location_code%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

Line 655: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%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
659: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type

Line 848: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

844: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
845: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
846: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
847: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
848: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%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

Line 851: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type

847: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
848: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%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

Line 855: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%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
859: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type

Line 861: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%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
859: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
860: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
861: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
862: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type
863: ,p_pgp_segment1 OUT NOCOPY pay_people_groups.segment1%type
864: ,p_pgp_segment2 OUT NOCOPY pay_people_groups.segment2%type
865: ,p_pgp_segment3 OUT NOCOPY pay_people_groups.segment3%type