APPS.PER_QH_MAINTAIN_UPDATE dependencies on PAY_PEOPLE_GROUPS

Line 183: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE

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

Line 184: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE

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

Line 185: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE

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

Line 186: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE

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

Line 187: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE

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

Line 188: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE

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

Line 189: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE

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

Line 190: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE

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

Line 191: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE

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

Line 192: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE

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

Line 193: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE

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

Line 194: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE

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

Line 195: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE

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

Line 196: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE

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

Line 197: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE

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

Line 198: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE

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

Line 199: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE

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

Line 200: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE

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

Line 201: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE

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

Line 202: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE

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

Line 203: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE

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

Line 204: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE

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

Line 205: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE

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

Line 206: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE

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

Line 207: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE

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

Line 208: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE

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

Line 209: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE

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

Line 210: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE

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

Line 211: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE

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

Line 212: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE

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

Line 770: l_pgp_rec pay_people_groups%ROWTYPE;

766: l_soft_coding_keyflex_id NUMBER;
767: l_no_managers_warning BOOLEAN;
768: l_other_manager_warning2 BOOLEAN;
769: --
770: l_pgp_rec pay_people_groups%ROWTYPE;
771: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;
772: --
773: l_app_object_version_number per_applications.object_version_number%TYPE;
774: l_application_id per_applications.application_id%TYPE;

Line 2883: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE

2879: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2880: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2881: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2882: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2883: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2884: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2885: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2886: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2887: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE

Line 2884: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE

2880: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2881: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2882: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2883: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2884: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2885: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2886: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2887: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2888: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE

Line 2885: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE

2881: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2882: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2883: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2884: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2885: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2886: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2887: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2888: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2889: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE

Line 2886: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE

2882: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2883: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2884: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2885: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2886: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2887: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2888: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2889: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2890: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE

Line 2887: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE

2883: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2884: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2885: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2886: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2887: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2888: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2889: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2890: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2891: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE

Line 2888: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE

2884: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2885: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2886: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2887: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2888: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2889: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2890: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2891: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2892: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE

Line 2889: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE

2885: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2886: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2887: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2888: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2889: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2890: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2891: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2892: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2893: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE

Line 2890: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE

2886: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2887: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2888: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2889: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2890: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2891: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2892: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2893: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2894: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE

Line 2891: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE

2887: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2888: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2889: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2890: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2891: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2892: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2893: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2894: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2895: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE

Line 2892: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE

2888: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2889: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2890: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2891: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2892: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2893: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2894: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2895: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2896: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE

Line 2893: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE

2889: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2890: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2891: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2892: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2893: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2894: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2895: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2896: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2897: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE

Line 2894: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE

2890: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2891: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2892: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2893: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2894: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2895: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2896: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2897: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2898: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE

Line 2895: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE

2891: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2892: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2893: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2894: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2895: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2896: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2897: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2898: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2899: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE

Line 2896: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE

2892: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2893: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2894: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2895: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2896: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2897: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2898: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2899: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2900: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE

Line 2897: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE

2893: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2894: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2895: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2896: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2897: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2898: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2899: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2900: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2901: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE

Line 2898: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE

2894: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2895: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2896: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2897: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2898: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2899: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2900: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2901: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2902: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE

Line 2899: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE

2895: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2896: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2897: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2898: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2899: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2900: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2901: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2902: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2903: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE

Line 2900: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE

2896: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2897: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2898: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2899: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2900: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2901: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2902: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2903: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2904: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE

Line 2901: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE

2897: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2898: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2899: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2900: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2901: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2902: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2903: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2904: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2905: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE

Line 2902: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE

2898: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2899: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2900: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2901: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2902: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2903: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2904: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2905: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2906: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE

Line 2903: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE

2899: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2900: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2901: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2902: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2903: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2904: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2905: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2906: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2907: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE

Line 2904: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE

2900: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2901: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2902: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2903: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2904: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2905: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2906: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2907: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2908: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE

Line 2905: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE

2901: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2902: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2903: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2904: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2905: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2906: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2907: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2908: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2909: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE

Line 2906: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE

2902: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2903: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2904: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2905: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2906: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2907: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2908: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2909: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2910: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE

Line 2907: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE

2903: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2904: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2905: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2906: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2907: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2908: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2909: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2910: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2911: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE

Line 2908: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE

2904: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2905: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2906: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2907: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2908: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2909: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2910: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2911: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2912: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE

Line 2909: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE

2905: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2906: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2907: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2908: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2909: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2910: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2911: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2912: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2913: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE

Line 2910: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE

2906: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2907: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2908: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2909: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2910: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2911: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2912: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2913: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2914: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE

Line 2911: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE

2907: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2908: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2909: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2910: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2911: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2912: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2913: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2914: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2915: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE

Line 2912: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE

2908: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2909: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2910: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2911: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2912: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2913: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2914: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2915: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2916: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE

Line 3473: l_pgp_rec pay_people_groups%ROWTYPE;

3469: l_soft_coding_keyflex_id NUMBER;
3470: l_no_managers_warning BOOLEAN;
3471: l_other_manager_warning2 BOOLEAN;
3472: --
3473: l_pgp_rec pay_people_groups%ROWTYPE;
3474: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;
3475: --
3476: l_app_object_version_number per_applications.object_version_number%TYPE;
3477: --

Line 3510: SELECT * FROM pay_people_groups

3506: l_gsp_post_process_warning3 varchar2(30);
3507: --
3508: CURSOR csr_pgp_rec
3509: (p_people_group_id NUMBER) IS
3510: SELECT * FROM pay_people_groups
3511: WHERE people_group_id=p_people_group_id;
3512: --
3513: CURSOR csr_scl_rec
3514: (p_soft_coding_keyflex_id NUMBER) IS