DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PAY_PEOPLE_GROUPS

Line 186: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE

182: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
183: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
184: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
185: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
186: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
187: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
188: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
189: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
190: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE

Line 187: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE

183: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
184: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
185: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
186: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
187: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
188: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
189: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
190: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
191: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE

Line 188: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE

184: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
185: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
186: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
187: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
188: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
189: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
190: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
191: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
192: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE

Line 189: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE

185: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
186: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
187: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
188: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
189: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
190: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
191: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
192: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
193: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE

Line 190: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE

186: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
187: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
188: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
189: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
190: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
191: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
192: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
193: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
194: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE

Line 191: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE

187: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
188: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
189: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
190: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
191: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
192: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
193: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
194: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
195: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE

Line 192: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE

188: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
189: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
190: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
191: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
192: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
193: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
194: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
195: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
196: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE

Line 193: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE

189: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
190: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
191: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
192: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
193: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
194: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
195: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
196: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
197: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE

Line 194: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE

190: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
191: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
192: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
193: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
194: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
195: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
196: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
197: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
198: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE

Line 195: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE

191: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
192: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
193: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
194: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
195: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
196: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
197: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
198: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
199: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE

Line 196: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE

192: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
193: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
194: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
195: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
196: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
197: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
198: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
199: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
200: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE

Line 197: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE

193: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
194: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
195: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
196: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
197: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
198: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
199: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
200: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
201: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE

Line 198: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE

194: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
195: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
196: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
197: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
198: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
199: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
200: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
201: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
202: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE

Line 199: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE

195: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
196: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
197: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
198: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
199: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
200: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
201: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
202: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
203: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE

Line 200: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE

196: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
197: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
198: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
199: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
200: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
201: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
202: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
203: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
204: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE

Line 201: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE

197: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
198: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
199: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
200: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
201: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
202: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
203: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
204: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
205: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE

Line 202: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE

198: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
199: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
200: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
201: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
202: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
203: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
204: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
205: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
206: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE

Line 203: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE

199: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
200: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
201: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
202: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
203: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
204: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
205: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
206: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
207: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE

Line 204: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE

200: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
201: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
202: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
203: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
204: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
205: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
206: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
207: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
208: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE

Line 205: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE

201: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
202: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
203: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
204: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
205: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
206: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
207: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
208: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
209: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE

Line 206: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE

202: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
203: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
204: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
205: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
206: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
207: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
208: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
209: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
210: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE

Line 207: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE

203: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
204: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
205: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
206: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
207: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
208: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
209: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
210: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
211: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE

Line 208: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE

204: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
205: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
206: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
207: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
208: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
209: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
210: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
211: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
212: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE

Line 209: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE

205: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
206: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
207: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
208: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
209: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
210: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
211: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
212: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
213: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE

Line 210: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE

206: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
207: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
208: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
209: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
210: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
211: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
212: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
213: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
214: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE

Line 211: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE

207: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
208: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
209: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
210: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
211: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
212: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
213: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
214: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
215: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE

Line 212: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE

208: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
209: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
210: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
211: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
212: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
213: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
214: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
215: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
216: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE

Line 213: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE

209: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
210: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
211: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
212: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
213: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
214: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
215: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
216: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
217: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE

Line 214: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE

210: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
211: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
212: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
213: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
214: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
215: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
216: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
217: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
218: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE

Line 215: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE

211: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
212: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
213: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
214: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
215: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
216: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
217: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
218: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
219: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE

Line 907: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE

903: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
904: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
905: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
906: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
907: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
908: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
909: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
910: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
911: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE

Line 908: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE

904: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
905: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
906: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
907: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
908: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
909: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
910: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
911: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
912: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE

Line 909: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE

905: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
906: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
907: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
908: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
909: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
910: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
911: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
912: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
913: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE

Line 910: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE

906: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
907: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
908: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
909: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
910: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
911: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
912: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
913: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
914: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE

Line 911: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE

907: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
908: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
909: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
910: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
911: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
912: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
913: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
914: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
915: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE

Line 912: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE

908: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
909: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
910: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
911: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
912: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
913: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
914: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
915: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
916: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE

Line 913: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE

909: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
910: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
911: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
912: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
913: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
914: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
915: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
916: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
917: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE

Line 914: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE

910: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
911: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
912: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
913: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
914: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
915: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
916: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
917: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
918: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE

Line 915: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE

911: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
912: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
913: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
914: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
915: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
916: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
917: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
918: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
919: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE

Line 916: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE

912: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
913: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
914: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
915: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
916: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
917: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
918: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
919: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
920: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE

Line 917: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE

913: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
914: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
915: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
916: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
917: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
918: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
919: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
920: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
921: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE

Line 918: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE

914: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
915: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
916: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
917: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
918: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
919: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
920: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
921: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
922: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE

Line 919: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE

915: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
916: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
917: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
918: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
919: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
920: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
921: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
922: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
923: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE

Line 920: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE

916: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
917: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
918: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
919: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
920: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
921: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
922: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
923: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
924: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE

Line 921: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE

917: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
918: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
919: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
920: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
921: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
922: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
923: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
924: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
925: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE

Line 922: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE

918: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
919: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
920: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
921: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
922: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
923: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
924: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
925: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
926: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE

Line 923: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE

919: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
920: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
921: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
922: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
923: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
924: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
925: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
926: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
927: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE

Line 924: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE

920: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
921: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
922: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
923: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
924: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
925: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
926: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
927: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
928: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE

Line 925: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE

921: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
922: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
923: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
924: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
925: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
926: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
927: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
928: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
929: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE

Line 926: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE

922: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
923: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
924: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
925: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
926: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
927: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
928: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
929: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
930: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE

Line 927: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE

923: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
924: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
925: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
926: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
927: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
928: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
929: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
930: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
931: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE

Line 928: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE

924: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
925: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
926: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
927: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
928: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
929: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
930: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
931: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
932: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE

Line 929: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE

925: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
926: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
927: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
928: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
929: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
930: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
931: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
932: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
933: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE

Line 930: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE

926: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
927: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
928: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
929: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
930: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
931: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
932: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
933: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
934: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE

Line 931: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE

927: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
928: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
929: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
930: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
931: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
932: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
933: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
934: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
935: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE

Line 932: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE

928: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
929: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
930: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
931: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
932: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
933: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
934: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
935: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
936: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE

Line 933: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE

929: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
930: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
931: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
932: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
933: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
934: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
935: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
936: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
937: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE

Line 934: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE

930: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
931: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
932: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
933: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
934: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
935: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
936: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
937: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
938: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE

Line 935: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE

931: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
932: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
933: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
934: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
935: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
936: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
937: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
938: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
939: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE

Line 936: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE

932: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
933: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
934: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
935: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
936: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
937: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
938: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
939: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
940: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE