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 2849: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE

2845: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2846: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2847: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2848: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2849: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2850: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2851: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2852: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2853: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE

Line 2850: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE

2846: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2847: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2848: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2849: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2850: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2851: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2852: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2853: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2854: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE

Line 2851: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE

2847: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2848: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2849: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2850: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2851: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2852: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2853: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2854: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2855: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE

Line 2852: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE

2848: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2849: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2850: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2851: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2852: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2853: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2854: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2855: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2856: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE

Line 2853: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE

2849: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2850: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2851: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2852: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2853: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2854: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2855: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2856: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2857: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE

Line 2854: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE

2850: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2851: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2852: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2853: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2854: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2855: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2856: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2857: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2858: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE

Line 2855: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE

2851: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2852: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2853: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2854: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2855: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2856: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2857: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2858: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2859: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE

Line 2856: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE

2852: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
2853: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2854: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2855: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2856: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2857: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2858: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2859: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2860: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE

Line 2857: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE

2853: ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
2854: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2855: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2856: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2857: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2858: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2859: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2860: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2861: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE

Line 2858: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE

2854: ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
2855: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2856: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2857: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2858: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2859: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2860: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2861: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2862: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE

Line 2859: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE

2855: ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
2856: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2857: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2858: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2859: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2860: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2861: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2862: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2863: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE

Line 2860: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE

2856: ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
2857: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2858: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2859: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2860: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2861: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2862: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2863: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2864: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE

Line 2861: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE

2857: ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
2858: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2859: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2860: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2861: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2862: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2863: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2864: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2865: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE

Line 2862: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE

2858: ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
2859: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2860: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2861: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2862: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2863: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2864: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2865: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2866: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE

Line 2863: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE

2859: ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
2860: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2861: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2862: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2863: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2864: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2865: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2866: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2867: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE

Line 2864: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE

2860: ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
2861: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2862: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2863: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2864: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2865: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2866: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2867: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2868: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE

Line 2865: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE

2861: ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
2862: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2863: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2864: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2865: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2866: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2867: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2868: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2869: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE

Line 2866: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE

2862: ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
2863: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2864: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2865: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2866: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2867: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2868: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2869: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2870: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE

Line 2867: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE

2863: ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
2864: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2865: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2866: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2867: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2868: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2869: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2870: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2871: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE

Line 2868: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE

2864: ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
2865: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2866: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2867: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2868: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2869: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2870: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2871: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2872: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE

Line 2869: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE

2865: ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
2866: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2867: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2868: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2869: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2870: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2871: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2872: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2873: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE

Line 2870: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE

2866: ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
2867: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2868: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2869: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2870: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2871: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2872: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2873: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2874: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE

Line 2871: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE

2867: ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
2868: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2869: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2870: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2871: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2872: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2873: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2874: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2875: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE

Line 2872: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE

2868: ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
2869: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2870: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2871: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2872: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2873: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2874: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2875: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2876: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE

Line 2873: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE

2869: ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
2870: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2871: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2872: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2873: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2874: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2875: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2876: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2877: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE

Line 2874: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE

2870: ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
2871: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2872: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2873: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2874: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2875: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2876: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2877: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2878: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE

Line 2875: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE

2871: ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
2872: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2873: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2874: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2875: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2876: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2877: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2878: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2879: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE

Line 2876: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE

2872: ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
2873: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2874: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2875: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2876: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2877: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2878: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2879: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2880: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE

Line 2877: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE

2873: ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
2874: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2875: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2876: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2877: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2878: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2879: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2880: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2881: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE

Line 2878: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE

2874: ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
2875: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2876: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2877: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2878: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2879: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2880: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2881: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2882: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE

Line 3439: l_pgp_rec pay_people_groups%ROWTYPE;

3435: l_soft_coding_keyflex_id NUMBER;
3436: l_no_managers_warning BOOLEAN;
3437: l_other_manager_warning2 BOOLEAN;
3438: --
3439: l_pgp_rec pay_people_groups%ROWTYPE;
3440: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;
3441: --
3442: l_app_object_version_number per_applications.object_version_number%TYPE;
3443: --

Line 3476: SELECT * FROM pay_people_groups

3472: l_gsp_post_process_warning3 varchar2(30);
3473: --
3474: CURSOR csr_pgp_rec
3475: (p_people_group_id NUMBER) IS
3476: SELECT * FROM pay_people_groups
3477: WHERE people_group_id=p_people_group_id;
3478: --
3479: CURSOR csr_scl_rec
3480: (p_soft_coding_keyflex_id NUMBER) IS