APPS.PER_QH_POPULATE dependencies on PAY_PEOPLE_GROUPS

Line 863: ,p_pgp_segment1 OUT NOCOPY pay_people_groups.segment1%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
866: ,p_pgp_segment4 OUT NOCOPY pay_people_groups.segment4%type
867: ,p_pgp_segment5 OUT NOCOPY pay_people_groups.segment5%type

Line 864: ,p_pgp_segment2 OUT NOCOPY pay_people_groups.segment2%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
866: ,p_pgp_segment4 OUT NOCOPY pay_people_groups.segment4%type
867: ,p_pgp_segment5 OUT NOCOPY pay_people_groups.segment5%type
868: ,p_pgp_segment6 OUT NOCOPY pay_people_groups.segment6%type

Line 865: ,p_pgp_segment3 OUT NOCOPY pay_people_groups.segment3%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
866: ,p_pgp_segment4 OUT NOCOPY pay_people_groups.segment4%type
867: ,p_pgp_segment5 OUT NOCOPY pay_people_groups.segment5%type
868: ,p_pgp_segment6 OUT NOCOPY pay_people_groups.segment6%type
869: ,p_pgp_segment7 OUT NOCOPY pay_people_groups.segment7%type

Line 866: ,p_pgp_segment4 OUT NOCOPY pay_people_groups.segment4%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
866: ,p_pgp_segment4 OUT NOCOPY pay_people_groups.segment4%type
867: ,p_pgp_segment5 OUT NOCOPY pay_people_groups.segment5%type
868: ,p_pgp_segment6 OUT NOCOPY pay_people_groups.segment6%type
869: ,p_pgp_segment7 OUT NOCOPY pay_people_groups.segment7%type
870: ,p_pgp_segment8 OUT NOCOPY pay_people_groups.segment8%type

Line 867: ,p_pgp_segment5 OUT NOCOPY pay_people_groups.segment5%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
866: ,p_pgp_segment4 OUT NOCOPY pay_people_groups.segment4%type
867: ,p_pgp_segment5 OUT NOCOPY pay_people_groups.segment5%type
868: ,p_pgp_segment6 OUT NOCOPY pay_people_groups.segment6%type
869: ,p_pgp_segment7 OUT NOCOPY pay_people_groups.segment7%type
870: ,p_pgp_segment8 OUT NOCOPY pay_people_groups.segment8%type
871: ,p_pgp_segment9 OUT NOCOPY pay_people_groups.segment9%type

Line 868: ,p_pgp_segment6 OUT NOCOPY pay_people_groups.segment6%type

864: ,p_pgp_segment2 OUT NOCOPY pay_people_groups.segment2%type
865: ,p_pgp_segment3 OUT NOCOPY pay_people_groups.segment3%type
866: ,p_pgp_segment4 OUT NOCOPY pay_people_groups.segment4%type
867: ,p_pgp_segment5 OUT NOCOPY pay_people_groups.segment5%type
868: ,p_pgp_segment6 OUT NOCOPY pay_people_groups.segment6%type
869: ,p_pgp_segment7 OUT NOCOPY pay_people_groups.segment7%type
870: ,p_pgp_segment8 OUT NOCOPY pay_people_groups.segment8%type
871: ,p_pgp_segment9 OUT NOCOPY pay_people_groups.segment9%type
872: ,p_pgp_segment10 OUT NOCOPY pay_people_groups.segment10%type

Line 869: ,p_pgp_segment7 OUT NOCOPY pay_people_groups.segment7%type

865: ,p_pgp_segment3 OUT NOCOPY pay_people_groups.segment3%type
866: ,p_pgp_segment4 OUT NOCOPY pay_people_groups.segment4%type
867: ,p_pgp_segment5 OUT NOCOPY pay_people_groups.segment5%type
868: ,p_pgp_segment6 OUT NOCOPY pay_people_groups.segment6%type
869: ,p_pgp_segment7 OUT NOCOPY pay_people_groups.segment7%type
870: ,p_pgp_segment8 OUT NOCOPY pay_people_groups.segment8%type
871: ,p_pgp_segment9 OUT NOCOPY pay_people_groups.segment9%type
872: ,p_pgp_segment10 OUT NOCOPY pay_people_groups.segment10%type
873: ,p_pgp_segment11 OUT NOCOPY pay_people_groups.segment11%type

Line 870: ,p_pgp_segment8 OUT NOCOPY pay_people_groups.segment8%type

866: ,p_pgp_segment4 OUT NOCOPY pay_people_groups.segment4%type
867: ,p_pgp_segment5 OUT NOCOPY pay_people_groups.segment5%type
868: ,p_pgp_segment6 OUT NOCOPY pay_people_groups.segment6%type
869: ,p_pgp_segment7 OUT NOCOPY pay_people_groups.segment7%type
870: ,p_pgp_segment8 OUT NOCOPY pay_people_groups.segment8%type
871: ,p_pgp_segment9 OUT NOCOPY pay_people_groups.segment9%type
872: ,p_pgp_segment10 OUT NOCOPY pay_people_groups.segment10%type
873: ,p_pgp_segment11 OUT NOCOPY pay_people_groups.segment11%type
874: ,p_pgp_segment12 OUT NOCOPY pay_people_groups.segment12%type

Line 871: ,p_pgp_segment9 OUT NOCOPY pay_people_groups.segment9%type

867: ,p_pgp_segment5 OUT NOCOPY pay_people_groups.segment5%type
868: ,p_pgp_segment6 OUT NOCOPY pay_people_groups.segment6%type
869: ,p_pgp_segment7 OUT NOCOPY pay_people_groups.segment7%type
870: ,p_pgp_segment8 OUT NOCOPY pay_people_groups.segment8%type
871: ,p_pgp_segment9 OUT NOCOPY pay_people_groups.segment9%type
872: ,p_pgp_segment10 OUT NOCOPY pay_people_groups.segment10%type
873: ,p_pgp_segment11 OUT NOCOPY pay_people_groups.segment11%type
874: ,p_pgp_segment12 OUT NOCOPY pay_people_groups.segment12%type
875: ,p_pgp_segment13 OUT NOCOPY pay_people_groups.segment13%type

Line 872: ,p_pgp_segment10 OUT NOCOPY pay_people_groups.segment10%type

868: ,p_pgp_segment6 OUT NOCOPY pay_people_groups.segment6%type
869: ,p_pgp_segment7 OUT NOCOPY pay_people_groups.segment7%type
870: ,p_pgp_segment8 OUT NOCOPY pay_people_groups.segment8%type
871: ,p_pgp_segment9 OUT NOCOPY pay_people_groups.segment9%type
872: ,p_pgp_segment10 OUT NOCOPY pay_people_groups.segment10%type
873: ,p_pgp_segment11 OUT NOCOPY pay_people_groups.segment11%type
874: ,p_pgp_segment12 OUT NOCOPY pay_people_groups.segment12%type
875: ,p_pgp_segment13 OUT NOCOPY pay_people_groups.segment13%type
876: ,p_pgp_segment14 OUT NOCOPY pay_people_groups.segment14%type

Line 873: ,p_pgp_segment11 OUT NOCOPY pay_people_groups.segment11%type

869: ,p_pgp_segment7 OUT NOCOPY pay_people_groups.segment7%type
870: ,p_pgp_segment8 OUT NOCOPY pay_people_groups.segment8%type
871: ,p_pgp_segment9 OUT NOCOPY pay_people_groups.segment9%type
872: ,p_pgp_segment10 OUT NOCOPY pay_people_groups.segment10%type
873: ,p_pgp_segment11 OUT NOCOPY pay_people_groups.segment11%type
874: ,p_pgp_segment12 OUT NOCOPY pay_people_groups.segment12%type
875: ,p_pgp_segment13 OUT NOCOPY pay_people_groups.segment13%type
876: ,p_pgp_segment14 OUT NOCOPY pay_people_groups.segment14%type
877: ,p_pgp_segment15 OUT NOCOPY pay_people_groups.segment15%type

Line 874: ,p_pgp_segment12 OUT NOCOPY pay_people_groups.segment12%type

870: ,p_pgp_segment8 OUT NOCOPY pay_people_groups.segment8%type
871: ,p_pgp_segment9 OUT NOCOPY pay_people_groups.segment9%type
872: ,p_pgp_segment10 OUT NOCOPY pay_people_groups.segment10%type
873: ,p_pgp_segment11 OUT NOCOPY pay_people_groups.segment11%type
874: ,p_pgp_segment12 OUT NOCOPY pay_people_groups.segment12%type
875: ,p_pgp_segment13 OUT NOCOPY pay_people_groups.segment13%type
876: ,p_pgp_segment14 OUT NOCOPY pay_people_groups.segment14%type
877: ,p_pgp_segment15 OUT NOCOPY pay_people_groups.segment15%type
878: ,p_pgp_segment16 OUT NOCOPY pay_people_groups.segment16%type

Line 875: ,p_pgp_segment13 OUT NOCOPY pay_people_groups.segment13%type

871: ,p_pgp_segment9 OUT NOCOPY pay_people_groups.segment9%type
872: ,p_pgp_segment10 OUT NOCOPY pay_people_groups.segment10%type
873: ,p_pgp_segment11 OUT NOCOPY pay_people_groups.segment11%type
874: ,p_pgp_segment12 OUT NOCOPY pay_people_groups.segment12%type
875: ,p_pgp_segment13 OUT NOCOPY pay_people_groups.segment13%type
876: ,p_pgp_segment14 OUT NOCOPY pay_people_groups.segment14%type
877: ,p_pgp_segment15 OUT NOCOPY pay_people_groups.segment15%type
878: ,p_pgp_segment16 OUT NOCOPY pay_people_groups.segment16%type
879: ,p_pgp_segment17 OUT NOCOPY pay_people_groups.segment17%type

Line 876: ,p_pgp_segment14 OUT NOCOPY pay_people_groups.segment14%type

872: ,p_pgp_segment10 OUT NOCOPY pay_people_groups.segment10%type
873: ,p_pgp_segment11 OUT NOCOPY pay_people_groups.segment11%type
874: ,p_pgp_segment12 OUT NOCOPY pay_people_groups.segment12%type
875: ,p_pgp_segment13 OUT NOCOPY pay_people_groups.segment13%type
876: ,p_pgp_segment14 OUT NOCOPY pay_people_groups.segment14%type
877: ,p_pgp_segment15 OUT NOCOPY pay_people_groups.segment15%type
878: ,p_pgp_segment16 OUT NOCOPY pay_people_groups.segment16%type
879: ,p_pgp_segment17 OUT NOCOPY pay_people_groups.segment17%type
880: ,p_pgp_segment18 OUT NOCOPY pay_people_groups.segment18%type

Line 877: ,p_pgp_segment15 OUT NOCOPY pay_people_groups.segment15%type

873: ,p_pgp_segment11 OUT NOCOPY pay_people_groups.segment11%type
874: ,p_pgp_segment12 OUT NOCOPY pay_people_groups.segment12%type
875: ,p_pgp_segment13 OUT NOCOPY pay_people_groups.segment13%type
876: ,p_pgp_segment14 OUT NOCOPY pay_people_groups.segment14%type
877: ,p_pgp_segment15 OUT NOCOPY pay_people_groups.segment15%type
878: ,p_pgp_segment16 OUT NOCOPY pay_people_groups.segment16%type
879: ,p_pgp_segment17 OUT NOCOPY pay_people_groups.segment17%type
880: ,p_pgp_segment18 OUT NOCOPY pay_people_groups.segment18%type
881: ,p_pgp_segment19 OUT NOCOPY pay_people_groups.segment19%type

Line 878: ,p_pgp_segment16 OUT NOCOPY pay_people_groups.segment16%type

874: ,p_pgp_segment12 OUT NOCOPY pay_people_groups.segment12%type
875: ,p_pgp_segment13 OUT NOCOPY pay_people_groups.segment13%type
876: ,p_pgp_segment14 OUT NOCOPY pay_people_groups.segment14%type
877: ,p_pgp_segment15 OUT NOCOPY pay_people_groups.segment15%type
878: ,p_pgp_segment16 OUT NOCOPY pay_people_groups.segment16%type
879: ,p_pgp_segment17 OUT NOCOPY pay_people_groups.segment17%type
880: ,p_pgp_segment18 OUT NOCOPY pay_people_groups.segment18%type
881: ,p_pgp_segment19 OUT NOCOPY pay_people_groups.segment19%type
882: ,p_pgp_segment20 OUT NOCOPY pay_people_groups.segment20%type

Line 879: ,p_pgp_segment17 OUT NOCOPY pay_people_groups.segment17%type

875: ,p_pgp_segment13 OUT NOCOPY pay_people_groups.segment13%type
876: ,p_pgp_segment14 OUT NOCOPY pay_people_groups.segment14%type
877: ,p_pgp_segment15 OUT NOCOPY pay_people_groups.segment15%type
878: ,p_pgp_segment16 OUT NOCOPY pay_people_groups.segment16%type
879: ,p_pgp_segment17 OUT NOCOPY pay_people_groups.segment17%type
880: ,p_pgp_segment18 OUT NOCOPY pay_people_groups.segment18%type
881: ,p_pgp_segment19 OUT NOCOPY pay_people_groups.segment19%type
882: ,p_pgp_segment20 OUT NOCOPY pay_people_groups.segment20%type
883: ,p_pgp_segment21 OUT NOCOPY pay_people_groups.segment21%type

Line 880: ,p_pgp_segment18 OUT NOCOPY pay_people_groups.segment18%type

876: ,p_pgp_segment14 OUT NOCOPY pay_people_groups.segment14%type
877: ,p_pgp_segment15 OUT NOCOPY pay_people_groups.segment15%type
878: ,p_pgp_segment16 OUT NOCOPY pay_people_groups.segment16%type
879: ,p_pgp_segment17 OUT NOCOPY pay_people_groups.segment17%type
880: ,p_pgp_segment18 OUT NOCOPY pay_people_groups.segment18%type
881: ,p_pgp_segment19 OUT NOCOPY pay_people_groups.segment19%type
882: ,p_pgp_segment20 OUT NOCOPY pay_people_groups.segment20%type
883: ,p_pgp_segment21 OUT NOCOPY pay_people_groups.segment21%type
884: ,p_pgp_segment22 OUT NOCOPY pay_people_groups.segment22%type

Line 881: ,p_pgp_segment19 OUT NOCOPY pay_people_groups.segment19%type

877: ,p_pgp_segment15 OUT NOCOPY pay_people_groups.segment15%type
878: ,p_pgp_segment16 OUT NOCOPY pay_people_groups.segment16%type
879: ,p_pgp_segment17 OUT NOCOPY pay_people_groups.segment17%type
880: ,p_pgp_segment18 OUT NOCOPY pay_people_groups.segment18%type
881: ,p_pgp_segment19 OUT NOCOPY pay_people_groups.segment19%type
882: ,p_pgp_segment20 OUT NOCOPY pay_people_groups.segment20%type
883: ,p_pgp_segment21 OUT NOCOPY pay_people_groups.segment21%type
884: ,p_pgp_segment22 OUT NOCOPY pay_people_groups.segment22%type
885: ,p_pgp_segment23 OUT NOCOPY pay_people_groups.segment23%type

Line 882: ,p_pgp_segment20 OUT NOCOPY pay_people_groups.segment20%type

878: ,p_pgp_segment16 OUT NOCOPY pay_people_groups.segment16%type
879: ,p_pgp_segment17 OUT NOCOPY pay_people_groups.segment17%type
880: ,p_pgp_segment18 OUT NOCOPY pay_people_groups.segment18%type
881: ,p_pgp_segment19 OUT NOCOPY pay_people_groups.segment19%type
882: ,p_pgp_segment20 OUT NOCOPY pay_people_groups.segment20%type
883: ,p_pgp_segment21 OUT NOCOPY pay_people_groups.segment21%type
884: ,p_pgp_segment22 OUT NOCOPY pay_people_groups.segment22%type
885: ,p_pgp_segment23 OUT NOCOPY pay_people_groups.segment23%type
886: ,p_pgp_segment24 OUT NOCOPY pay_people_groups.segment24%type

Line 883: ,p_pgp_segment21 OUT NOCOPY pay_people_groups.segment21%type

879: ,p_pgp_segment17 OUT NOCOPY pay_people_groups.segment17%type
880: ,p_pgp_segment18 OUT NOCOPY pay_people_groups.segment18%type
881: ,p_pgp_segment19 OUT NOCOPY pay_people_groups.segment19%type
882: ,p_pgp_segment20 OUT NOCOPY pay_people_groups.segment20%type
883: ,p_pgp_segment21 OUT NOCOPY pay_people_groups.segment21%type
884: ,p_pgp_segment22 OUT NOCOPY pay_people_groups.segment22%type
885: ,p_pgp_segment23 OUT NOCOPY pay_people_groups.segment23%type
886: ,p_pgp_segment24 OUT NOCOPY pay_people_groups.segment24%type
887: ,p_pgp_segment25 OUT NOCOPY pay_people_groups.segment25%type

Line 884: ,p_pgp_segment22 OUT NOCOPY pay_people_groups.segment22%type

880: ,p_pgp_segment18 OUT NOCOPY pay_people_groups.segment18%type
881: ,p_pgp_segment19 OUT NOCOPY pay_people_groups.segment19%type
882: ,p_pgp_segment20 OUT NOCOPY pay_people_groups.segment20%type
883: ,p_pgp_segment21 OUT NOCOPY pay_people_groups.segment21%type
884: ,p_pgp_segment22 OUT NOCOPY pay_people_groups.segment22%type
885: ,p_pgp_segment23 OUT NOCOPY pay_people_groups.segment23%type
886: ,p_pgp_segment24 OUT NOCOPY pay_people_groups.segment24%type
887: ,p_pgp_segment25 OUT NOCOPY pay_people_groups.segment25%type
888: ,p_pgp_segment26 OUT NOCOPY pay_people_groups.segment26%type

Line 885: ,p_pgp_segment23 OUT NOCOPY pay_people_groups.segment23%type

881: ,p_pgp_segment19 OUT NOCOPY pay_people_groups.segment19%type
882: ,p_pgp_segment20 OUT NOCOPY pay_people_groups.segment20%type
883: ,p_pgp_segment21 OUT NOCOPY pay_people_groups.segment21%type
884: ,p_pgp_segment22 OUT NOCOPY pay_people_groups.segment22%type
885: ,p_pgp_segment23 OUT NOCOPY pay_people_groups.segment23%type
886: ,p_pgp_segment24 OUT NOCOPY pay_people_groups.segment24%type
887: ,p_pgp_segment25 OUT NOCOPY pay_people_groups.segment25%type
888: ,p_pgp_segment26 OUT NOCOPY pay_people_groups.segment26%type
889: ,p_pgp_segment27 OUT NOCOPY pay_people_groups.segment27%type

Line 886: ,p_pgp_segment24 OUT NOCOPY pay_people_groups.segment24%type

882: ,p_pgp_segment20 OUT NOCOPY pay_people_groups.segment20%type
883: ,p_pgp_segment21 OUT NOCOPY pay_people_groups.segment21%type
884: ,p_pgp_segment22 OUT NOCOPY pay_people_groups.segment22%type
885: ,p_pgp_segment23 OUT NOCOPY pay_people_groups.segment23%type
886: ,p_pgp_segment24 OUT NOCOPY pay_people_groups.segment24%type
887: ,p_pgp_segment25 OUT NOCOPY pay_people_groups.segment25%type
888: ,p_pgp_segment26 OUT NOCOPY pay_people_groups.segment26%type
889: ,p_pgp_segment27 OUT NOCOPY pay_people_groups.segment27%type
890: ,p_pgp_segment28 OUT NOCOPY pay_people_groups.segment28%type

Line 887: ,p_pgp_segment25 OUT NOCOPY pay_people_groups.segment25%type

883: ,p_pgp_segment21 OUT NOCOPY pay_people_groups.segment21%type
884: ,p_pgp_segment22 OUT NOCOPY pay_people_groups.segment22%type
885: ,p_pgp_segment23 OUT NOCOPY pay_people_groups.segment23%type
886: ,p_pgp_segment24 OUT NOCOPY pay_people_groups.segment24%type
887: ,p_pgp_segment25 OUT NOCOPY pay_people_groups.segment25%type
888: ,p_pgp_segment26 OUT NOCOPY pay_people_groups.segment26%type
889: ,p_pgp_segment27 OUT NOCOPY pay_people_groups.segment27%type
890: ,p_pgp_segment28 OUT NOCOPY pay_people_groups.segment28%type
891: ,p_pgp_segment29 OUT NOCOPY pay_people_groups.segment29%type

Line 888: ,p_pgp_segment26 OUT NOCOPY pay_people_groups.segment26%type

884: ,p_pgp_segment22 OUT NOCOPY pay_people_groups.segment22%type
885: ,p_pgp_segment23 OUT NOCOPY pay_people_groups.segment23%type
886: ,p_pgp_segment24 OUT NOCOPY pay_people_groups.segment24%type
887: ,p_pgp_segment25 OUT NOCOPY pay_people_groups.segment25%type
888: ,p_pgp_segment26 OUT NOCOPY pay_people_groups.segment26%type
889: ,p_pgp_segment27 OUT NOCOPY pay_people_groups.segment27%type
890: ,p_pgp_segment28 OUT NOCOPY pay_people_groups.segment28%type
891: ,p_pgp_segment29 OUT NOCOPY pay_people_groups.segment29%type
892: ,p_pgp_segment30 OUT NOCOPY pay_people_groups.segment30%type

Line 889: ,p_pgp_segment27 OUT NOCOPY pay_people_groups.segment27%type

885: ,p_pgp_segment23 OUT NOCOPY pay_people_groups.segment23%type
886: ,p_pgp_segment24 OUT NOCOPY pay_people_groups.segment24%type
887: ,p_pgp_segment25 OUT NOCOPY pay_people_groups.segment25%type
888: ,p_pgp_segment26 OUT NOCOPY pay_people_groups.segment26%type
889: ,p_pgp_segment27 OUT NOCOPY pay_people_groups.segment27%type
890: ,p_pgp_segment28 OUT NOCOPY pay_people_groups.segment28%type
891: ,p_pgp_segment29 OUT NOCOPY pay_people_groups.segment29%type
892: ,p_pgp_segment30 OUT NOCOPY pay_people_groups.segment30%type
893: ) is

Line 890: ,p_pgp_segment28 OUT NOCOPY pay_people_groups.segment28%type

886: ,p_pgp_segment24 OUT NOCOPY pay_people_groups.segment24%type
887: ,p_pgp_segment25 OUT NOCOPY pay_people_groups.segment25%type
888: ,p_pgp_segment26 OUT NOCOPY pay_people_groups.segment26%type
889: ,p_pgp_segment27 OUT NOCOPY pay_people_groups.segment27%type
890: ,p_pgp_segment28 OUT NOCOPY pay_people_groups.segment28%type
891: ,p_pgp_segment29 OUT NOCOPY pay_people_groups.segment29%type
892: ,p_pgp_segment30 OUT NOCOPY pay_people_groups.segment30%type
893: ) is
894: --

Line 891: ,p_pgp_segment29 OUT NOCOPY pay_people_groups.segment29%type

887: ,p_pgp_segment25 OUT NOCOPY pay_people_groups.segment25%type
888: ,p_pgp_segment26 OUT NOCOPY pay_people_groups.segment26%type
889: ,p_pgp_segment27 OUT NOCOPY pay_people_groups.segment27%type
890: ,p_pgp_segment28 OUT NOCOPY pay_people_groups.segment28%type
891: ,p_pgp_segment29 OUT NOCOPY pay_people_groups.segment29%type
892: ,p_pgp_segment30 OUT NOCOPY pay_people_groups.segment30%type
893: ) is
894: --
895: l_proc varchar2(72) :=g_package||'get_vac_defaults';

Line 892: ,p_pgp_segment30 OUT NOCOPY pay_people_groups.segment30%type

888: ,p_pgp_segment26 OUT NOCOPY pay_people_groups.segment26%type
889: ,p_pgp_segment27 OUT NOCOPY pay_people_groups.segment27%type
890: ,p_pgp_segment28 OUT NOCOPY pay_people_groups.segment28%type
891: ,p_pgp_segment29 OUT NOCOPY pay_people_groups.segment29%type
892: ,p_pgp_segment30 OUT NOCOPY pay_people_groups.segment30%type
893: ) is
894: --
895: l_proc varchar2(72) :=g_package||'get_vac_defaults';
896: l_recruiter_id per_all_assignments_f.recruiter_id%type;

Line 904: l_pgp_rec pay_people_groups%rowtype;

900: l_job_id per_all_assignments_f.job_id%type;
901: l_location_id per_all_assignments_f.location_id%type;
902: l_organization_id per_all_assignments_f.organization_id%type;
903: l_people_group_id per_all_assignments_f.people_group_id%type;
904: l_pgp_rec pay_people_groups%rowtype;
905: l_vacancy_id per_vacancies.vacancy_id%type;
906: l_vacancy per_vacancies.name%type;
907: l_dummy number;
908: --

Line 922: from pay_people_groups

918: where vacancy_id=p_vacancy_id;
919: --
920: cursor get_pgp(pgp_id number) is
921: select *
922: from pay_people_groups
923: where people_group_id=pgp_id;
924: --
925: cursor chk_job_pos(ln_job_id number
926: ,ln_position_id number) is