DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PAY_PEOPLE_GROUPS

Line 179: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE

175: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
176: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
177: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
178: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
179: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
180: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
181: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
182: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
183: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE

Line 180: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE

176: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
177: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
178: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
179: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
180: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
181: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
182: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
183: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
184: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE

Line 181: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE

177: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
178: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
179: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
180: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
181: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
182: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
183: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
184: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
185: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE

Line 182: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE

178: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
179: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
180: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
181: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
182: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
183: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
184: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
185: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
186: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE

Line 183: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE

179: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
180: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
181: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
182: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
183: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
184: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
185: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
186: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
187: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE

Line 184: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE

180: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
181: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
182: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
183: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
184: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
185: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
186: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
187: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
188: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE

Line 185: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE

181: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
182: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
183: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
184: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
185: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
186: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
187: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
188: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
189: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE

Line 186: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE

182: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
183: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
184: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
185: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
186: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
187: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
188: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
189: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
190: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE

Line 187: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE

183: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
184: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
185: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
186: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
187: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
188: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
189: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
190: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
191: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE

Line 188: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE

184: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
185: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
186: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
187: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
188: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
189: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
190: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
191: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
192: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE

Line 189: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE

185: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
186: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
187: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
188: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
189: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
190: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
191: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
192: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
193: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE

Line 190: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE

186: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
187: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
188: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
189: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
190: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
191: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
192: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
193: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
194: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE

Line 191: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE

187: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
188: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
189: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
190: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
191: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
192: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
193: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
194: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
195: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE

Line 192: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE

188: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
189: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
190: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
191: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
192: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
193: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
194: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
195: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
196: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE

Line 193: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE

189: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
190: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
191: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
192: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
193: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
194: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
195: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
196: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
197: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE

Line 194: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE

190: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
191: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
192: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
193: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
194: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
195: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
196: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
197: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
198: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE

Line 195: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE

191: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
192: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
193: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
194: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
195: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
196: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
197: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
198: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
199: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE

Line 196: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE

192: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
193: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
194: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
195: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
196: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
197: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
198: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
199: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
200: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE

Line 197: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE

193: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
194: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
195: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
196: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
197: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
198: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
199: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
200: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
201: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE

Line 198: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE

194: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
195: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
196: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
197: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
198: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
199: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
200: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
201: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
202: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE

Line 199: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE

195: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
196: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
197: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
198: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
199: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
200: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
201: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
202: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
203: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE

Line 200: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE

196: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
197: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
198: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
199: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
200: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
201: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
202: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
203: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
204: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE

Line 201: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE

197: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
198: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
199: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
200: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
201: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
202: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
203: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
204: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
205: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE

Line 202: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE

198: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
199: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
200: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
201: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
202: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
203: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
204: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
205: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
206: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE

Line 203: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE

199: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
200: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
201: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
202: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
203: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
204: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
205: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
206: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
207: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE

Line 204: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE

200: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
201: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
202: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
203: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
204: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
205: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
206: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
207: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
208: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE

Line 205: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE

201: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
202: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
203: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
204: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
205: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
206: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
207: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
208: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
209: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE

Line 206: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE

202: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
203: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
204: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
205: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
206: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
207: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
208: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
209: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
210: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE

Line 207: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE

203: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
204: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
205: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
206: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
207: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
208: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
209: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
210: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
211: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE

Line 208: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE

204: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
205: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
206: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
207: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
208: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
209: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
210: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
211: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
212: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE

Line 900: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE

896: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
897: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
898: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
899: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
900: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
901: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
902: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
903: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
904: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE

Line 901: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE

897: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
898: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
899: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
900: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
901: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
902: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
903: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
904: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
905: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE

Line 902: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE

898: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
899: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
900: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
901: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
902: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
903: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
904: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
905: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
906: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE

Line 903: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE

899: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
900: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
901: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
902: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
903: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
904: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
905: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
906: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
907: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE

Line 904: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE

900: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
901: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
902: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
903: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
904: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
905: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
906: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
907: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
908: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE

Line 905: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE

901: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
902: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
903: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
904: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
905: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
906: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
907: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
908: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
909: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE

Line 906: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE

902: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
903: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
904: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
905: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
906: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
907: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
908: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
909: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
910: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE

Line 907: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE

903: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
904: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
905: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
906: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
907: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
908: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
909: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
910: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
911: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE

Line 908: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE

904: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
905: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
906: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
907: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
908: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
909: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
910: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
911: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
912: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE

Line 909: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE

905: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
906: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
907: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
908: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
909: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
910: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
911: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
912: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
913: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE

Line 910: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE

906: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
907: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
908: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
909: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
910: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
911: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
912: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
913: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
914: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE

Line 911: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE

907: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
908: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
909: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
910: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
911: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
912: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
913: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
914: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
915: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE

Line 912: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE

908: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
909: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
910: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
911: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
912: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
913: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
914: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
915: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
916: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE

Line 913: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE

909: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
910: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
911: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
912: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
913: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
914: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
915: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
916: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
917: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE

Line 914: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE

910: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
911: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
912: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
913: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
914: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
915: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
916: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
917: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
918: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE

Line 915: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE

911: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
912: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
913: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
914: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
915: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
916: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
917: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
918: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
919: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE

Line 916: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE

912: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
913: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
914: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
915: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
916: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
917: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
918: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
919: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
920: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE

Line 917: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE

913: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
914: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
915: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
916: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
917: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
918: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
919: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
920: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
921: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE

Line 918: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE

914: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
915: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
916: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
917: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
918: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
919: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
920: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
921: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
922: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE

Line 919: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE

915: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
916: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
917: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
918: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
919: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
920: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
921: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
922: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
923: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE

Line 920: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE

916: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
917: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
918: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
919: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
920: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
921: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
922: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
923: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
924: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE

Line 921: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE

917: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
918: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
919: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
920: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
921: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
922: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
923: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
924: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
925: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE

Line 922: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE

918: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
919: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
920: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
921: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
922: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
923: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
924: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
925: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
926: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE

Line 923: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE

919: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
920: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
921: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
922: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
923: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
924: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
925: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
926: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
927: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE

Line 924: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE

920: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
921: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
922: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
923: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
924: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
925: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
926: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
927: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
928: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE

Line 925: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE

921: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
922: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
923: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
924: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
925: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
926: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
927: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
928: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
929: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE

Line 926: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE

922: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
923: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
924: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
925: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
926: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
927: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
928: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
929: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
930: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE

Line 927: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE

923: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
924: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
925: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
926: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
927: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
928: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
929: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
930: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
931: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE

Line 928: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE

924: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
925: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
926: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
927: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
928: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
929: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
930: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
931: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
932: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE

Line 929: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE

925: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
926: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
927: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
928: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
929: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
930: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
931: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
932: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
933: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE