APPS.PER_QH_FIND_QUERY dependencies on PAY_PEOPLE_GROUPS

Line 276: ,pgp_segment1 pay_people_groups.segment1%type

272: ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type
273: ,recruitment_activity per_recruitment_activities.name%type
274: ,source_organization hr_all_organization_units.name%type
275: ,organization hr_all_organization_units.name%type
276: ,pgp_segment1 pay_people_groups.segment1%type
277: ,pgp_segment1_v varchar2(150)
278: ,pgp_segment1_m varchar2(150)
279: ,pgp_segment2 pay_people_groups.segment2%type
280: ,pgp_segment2_v varchar2(150)

Line 279: ,pgp_segment2 pay_people_groups.segment2%type

275: ,organization hr_all_organization_units.name%type
276: ,pgp_segment1 pay_people_groups.segment1%type
277: ,pgp_segment1_v varchar2(150)
278: ,pgp_segment1_m varchar2(150)
279: ,pgp_segment2 pay_people_groups.segment2%type
280: ,pgp_segment2_v varchar2(150)
281: ,pgp_segment2_m varchar2(150)
282: ,pgp_segment3 pay_people_groups.segment3%type
283: ,pgp_segment3_v varchar2(150)

Line 282: ,pgp_segment3 pay_people_groups.segment3%type

278: ,pgp_segment1_m varchar2(150)
279: ,pgp_segment2 pay_people_groups.segment2%type
280: ,pgp_segment2_v varchar2(150)
281: ,pgp_segment2_m varchar2(150)
282: ,pgp_segment3 pay_people_groups.segment3%type
283: ,pgp_segment3_v varchar2(150)
284: ,pgp_segment3_m varchar2(150)
285: ,pgp_segment4 pay_people_groups.segment4%type
286: ,pgp_segment4_v varchar2(150)

Line 285: ,pgp_segment4 pay_people_groups.segment4%type

281: ,pgp_segment2_m varchar2(150)
282: ,pgp_segment3 pay_people_groups.segment3%type
283: ,pgp_segment3_v varchar2(150)
284: ,pgp_segment3_m varchar2(150)
285: ,pgp_segment4 pay_people_groups.segment4%type
286: ,pgp_segment4_v varchar2(150)
287: ,pgp_segment4_m varchar2(150)
288: ,pgp_segment5 pay_people_groups.segment5%type
289: ,pgp_segment5_v varchar2(150)

Line 288: ,pgp_segment5 pay_people_groups.segment5%type

284: ,pgp_segment3_m varchar2(150)
285: ,pgp_segment4 pay_people_groups.segment4%type
286: ,pgp_segment4_v varchar2(150)
287: ,pgp_segment4_m varchar2(150)
288: ,pgp_segment5 pay_people_groups.segment5%type
289: ,pgp_segment5_v varchar2(150)
290: ,pgp_segment5_m varchar2(150)
291: ,pgp_segment6 pay_people_groups.segment6%type
292: ,pgp_segment6_v varchar2(150)

Line 291: ,pgp_segment6 pay_people_groups.segment6%type

287: ,pgp_segment4_m varchar2(150)
288: ,pgp_segment5 pay_people_groups.segment5%type
289: ,pgp_segment5_v varchar2(150)
290: ,pgp_segment5_m varchar2(150)
291: ,pgp_segment6 pay_people_groups.segment6%type
292: ,pgp_segment6_v varchar2(150)
293: ,pgp_segment6_m varchar2(150)
294: ,pgp_segment7 pay_people_groups.segment7%type
295: ,pgp_segment7_v varchar2(150)

Line 294: ,pgp_segment7 pay_people_groups.segment7%type

290: ,pgp_segment5_m varchar2(150)
291: ,pgp_segment6 pay_people_groups.segment6%type
292: ,pgp_segment6_v varchar2(150)
293: ,pgp_segment6_m varchar2(150)
294: ,pgp_segment7 pay_people_groups.segment7%type
295: ,pgp_segment7_v varchar2(150)
296: ,pgp_segment7_m varchar2(150)
297: ,pgp_segment8 pay_people_groups.segment8%type
298: ,pgp_segment8_v varchar2(150)

Line 297: ,pgp_segment8 pay_people_groups.segment8%type

293: ,pgp_segment6_m varchar2(150)
294: ,pgp_segment7 pay_people_groups.segment7%type
295: ,pgp_segment7_v varchar2(150)
296: ,pgp_segment7_m varchar2(150)
297: ,pgp_segment8 pay_people_groups.segment8%type
298: ,pgp_segment8_v varchar2(150)
299: ,pgp_segment8_m varchar2(150)
300: ,pgp_segment9 pay_people_groups.segment9%type
301: ,pgp_segment9_v varchar2(150)

Line 300: ,pgp_segment9 pay_people_groups.segment9%type

296: ,pgp_segment7_m varchar2(150)
297: ,pgp_segment8 pay_people_groups.segment8%type
298: ,pgp_segment8_v varchar2(150)
299: ,pgp_segment8_m varchar2(150)
300: ,pgp_segment9 pay_people_groups.segment9%type
301: ,pgp_segment9_v varchar2(150)
302: ,pgp_segment9_m varchar2(150)
303: ,pgp_segment10 pay_people_groups.segment10%type
304: ,pgp_segment10_v varchar2(150)

Line 303: ,pgp_segment10 pay_people_groups.segment10%type

299: ,pgp_segment8_m varchar2(150)
300: ,pgp_segment9 pay_people_groups.segment9%type
301: ,pgp_segment9_v varchar2(150)
302: ,pgp_segment9_m varchar2(150)
303: ,pgp_segment10 pay_people_groups.segment10%type
304: ,pgp_segment10_v varchar2(150)
305: ,pgp_segment10_m varchar2(150)
306: ,pgp_segment11 pay_people_groups.segment11%type
307: ,pgp_segment11_v varchar2(150)

Line 306: ,pgp_segment11 pay_people_groups.segment11%type

302: ,pgp_segment9_m varchar2(150)
303: ,pgp_segment10 pay_people_groups.segment10%type
304: ,pgp_segment10_v varchar2(150)
305: ,pgp_segment10_m varchar2(150)
306: ,pgp_segment11 pay_people_groups.segment11%type
307: ,pgp_segment11_v varchar2(150)
308: ,pgp_segment11_m varchar2(150)
309: ,pgp_segment12 pay_people_groups.segment12%type
310: ,pgp_segment12_v varchar2(150)

Line 309: ,pgp_segment12 pay_people_groups.segment12%type

305: ,pgp_segment10_m varchar2(150)
306: ,pgp_segment11 pay_people_groups.segment11%type
307: ,pgp_segment11_v varchar2(150)
308: ,pgp_segment11_m varchar2(150)
309: ,pgp_segment12 pay_people_groups.segment12%type
310: ,pgp_segment12_v varchar2(150)
311: ,pgp_segment12_m varchar2(150)
312: ,pgp_segment13 pay_people_groups.segment13%type
313: ,pgp_segment13_v varchar2(150)

Line 312: ,pgp_segment13 pay_people_groups.segment13%type

308: ,pgp_segment11_m varchar2(150)
309: ,pgp_segment12 pay_people_groups.segment12%type
310: ,pgp_segment12_v varchar2(150)
311: ,pgp_segment12_m varchar2(150)
312: ,pgp_segment13 pay_people_groups.segment13%type
313: ,pgp_segment13_v varchar2(150)
314: ,pgp_segment13_m varchar2(150)
315: ,pgp_segment14 pay_people_groups.segment14%type
316: ,pgp_segment14_v varchar2(150)

Line 315: ,pgp_segment14 pay_people_groups.segment14%type

311: ,pgp_segment12_m varchar2(150)
312: ,pgp_segment13 pay_people_groups.segment13%type
313: ,pgp_segment13_v varchar2(150)
314: ,pgp_segment13_m varchar2(150)
315: ,pgp_segment14 pay_people_groups.segment14%type
316: ,pgp_segment14_v varchar2(150)
317: ,pgp_segment14_m varchar2(150)
318: ,pgp_segment15 pay_people_groups.segment15%type
319: ,pgp_segment15_v varchar2(150)

Line 318: ,pgp_segment15 pay_people_groups.segment15%type

314: ,pgp_segment13_m varchar2(150)
315: ,pgp_segment14 pay_people_groups.segment14%type
316: ,pgp_segment14_v varchar2(150)
317: ,pgp_segment14_m varchar2(150)
318: ,pgp_segment15 pay_people_groups.segment15%type
319: ,pgp_segment15_v varchar2(150)
320: ,pgp_segment15_m varchar2(150)
321: ,pgp_segment16 pay_people_groups.segment16%type
322: ,pgp_segment16_v varchar2(150)

Line 321: ,pgp_segment16 pay_people_groups.segment16%type

317: ,pgp_segment14_m varchar2(150)
318: ,pgp_segment15 pay_people_groups.segment15%type
319: ,pgp_segment15_v varchar2(150)
320: ,pgp_segment15_m varchar2(150)
321: ,pgp_segment16 pay_people_groups.segment16%type
322: ,pgp_segment16_v varchar2(150)
323: ,pgp_segment16_m varchar2(150)
324: ,pgp_segment17 pay_people_groups.segment17%type
325: ,pgp_segment17_v varchar2(150)

Line 324: ,pgp_segment17 pay_people_groups.segment17%type

320: ,pgp_segment15_m varchar2(150)
321: ,pgp_segment16 pay_people_groups.segment16%type
322: ,pgp_segment16_v varchar2(150)
323: ,pgp_segment16_m varchar2(150)
324: ,pgp_segment17 pay_people_groups.segment17%type
325: ,pgp_segment17_v varchar2(150)
326: ,pgp_segment17_m varchar2(150)
327: ,pgp_segment18 pay_people_groups.segment18%type
328: ,pgp_segment18_v varchar2(150)

Line 327: ,pgp_segment18 pay_people_groups.segment18%type

323: ,pgp_segment16_m varchar2(150)
324: ,pgp_segment17 pay_people_groups.segment17%type
325: ,pgp_segment17_v varchar2(150)
326: ,pgp_segment17_m varchar2(150)
327: ,pgp_segment18 pay_people_groups.segment18%type
328: ,pgp_segment18_v varchar2(150)
329: ,pgp_segment18_m varchar2(150)
330: ,pgp_segment19 pay_people_groups.segment19%type
331: ,pgp_segment19_v varchar2(150)

Line 330: ,pgp_segment19 pay_people_groups.segment19%type

326: ,pgp_segment17_m varchar2(150)
327: ,pgp_segment18 pay_people_groups.segment18%type
328: ,pgp_segment18_v varchar2(150)
329: ,pgp_segment18_m varchar2(150)
330: ,pgp_segment19 pay_people_groups.segment19%type
331: ,pgp_segment19_v varchar2(150)
332: ,pgp_segment19_m varchar2(150)
333: ,pgp_segment20 pay_people_groups.segment20%type
334: ,pgp_segment20_v varchar2(150)

Line 333: ,pgp_segment20 pay_people_groups.segment20%type

329: ,pgp_segment18_m varchar2(150)
330: ,pgp_segment19 pay_people_groups.segment19%type
331: ,pgp_segment19_v varchar2(150)
332: ,pgp_segment19_m varchar2(150)
333: ,pgp_segment20 pay_people_groups.segment20%type
334: ,pgp_segment20_v varchar2(150)
335: ,pgp_segment20_m varchar2(150)
336: ,pgp_segment21 pay_people_groups.segment21%type
337: ,pgp_segment21_v varchar2(150)

Line 336: ,pgp_segment21 pay_people_groups.segment21%type

332: ,pgp_segment19_m varchar2(150)
333: ,pgp_segment20 pay_people_groups.segment20%type
334: ,pgp_segment20_v varchar2(150)
335: ,pgp_segment20_m varchar2(150)
336: ,pgp_segment21 pay_people_groups.segment21%type
337: ,pgp_segment21_v varchar2(150)
338: ,pgp_segment21_m varchar2(150)
339: ,pgp_segment22 pay_people_groups.segment22%type
340: ,pgp_segment22_v varchar2(150)

Line 339: ,pgp_segment22 pay_people_groups.segment22%type

335: ,pgp_segment20_m varchar2(150)
336: ,pgp_segment21 pay_people_groups.segment21%type
337: ,pgp_segment21_v varchar2(150)
338: ,pgp_segment21_m varchar2(150)
339: ,pgp_segment22 pay_people_groups.segment22%type
340: ,pgp_segment22_v varchar2(150)
341: ,pgp_segment22_m varchar2(150)
342: ,pgp_segment23 pay_people_groups.segment23%type
343: ,pgp_segment23_v varchar2(150)

Line 342: ,pgp_segment23 pay_people_groups.segment23%type

338: ,pgp_segment21_m varchar2(150)
339: ,pgp_segment22 pay_people_groups.segment22%type
340: ,pgp_segment22_v varchar2(150)
341: ,pgp_segment22_m varchar2(150)
342: ,pgp_segment23 pay_people_groups.segment23%type
343: ,pgp_segment23_v varchar2(150)
344: ,pgp_segment23_m varchar2(150)
345: ,pgp_segment24 pay_people_groups.segment24%type
346: ,pgp_segment24_v varchar2(150)

Line 345: ,pgp_segment24 pay_people_groups.segment24%type

341: ,pgp_segment22_m varchar2(150)
342: ,pgp_segment23 pay_people_groups.segment23%type
343: ,pgp_segment23_v varchar2(150)
344: ,pgp_segment23_m varchar2(150)
345: ,pgp_segment24 pay_people_groups.segment24%type
346: ,pgp_segment24_v varchar2(150)
347: ,pgp_segment24_m varchar2(150)
348: ,pgp_segment25 pay_people_groups.segment25%type
349: ,pgp_segment25_v varchar2(150)

Line 348: ,pgp_segment25 pay_people_groups.segment25%type

344: ,pgp_segment23_m varchar2(150)
345: ,pgp_segment24 pay_people_groups.segment24%type
346: ,pgp_segment24_v varchar2(150)
347: ,pgp_segment24_m varchar2(150)
348: ,pgp_segment25 pay_people_groups.segment25%type
349: ,pgp_segment25_v varchar2(150)
350: ,pgp_segment25_m varchar2(150)
351: ,pgp_segment26 pay_people_groups.segment26%type
352: ,pgp_segment26_v varchar2(150)

Line 351: ,pgp_segment26 pay_people_groups.segment26%type

347: ,pgp_segment24_m varchar2(150)
348: ,pgp_segment25 pay_people_groups.segment25%type
349: ,pgp_segment25_v varchar2(150)
350: ,pgp_segment25_m varchar2(150)
351: ,pgp_segment26 pay_people_groups.segment26%type
352: ,pgp_segment26_v varchar2(150)
353: ,pgp_segment26_m varchar2(150)
354: ,pgp_segment27 pay_people_groups.segment27%type
355: ,pgp_segment27_v varchar2(150)

Line 354: ,pgp_segment27 pay_people_groups.segment27%type

350: ,pgp_segment25_m varchar2(150)
351: ,pgp_segment26 pay_people_groups.segment26%type
352: ,pgp_segment26_v varchar2(150)
353: ,pgp_segment26_m varchar2(150)
354: ,pgp_segment27 pay_people_groups.segment27%type
355: ,pgp_segment27_v varchar2(150)
356: ,pgp_segment27_m varchar2(150)
357: ,pgp_segment28 pay_people_groups.segment28%type
358: ,pgp_segment28_v varchar2(150)

Line 357: ,pgp_segment28 pay_people_groups.segment28%type

353: ,pgp_segment26_m varchar2(150)
354: ,pgp_segment27 pay_people_groups.segment27%type
355: ,pgp_segment27_v varchar2(150)
356: ,pgp_segment27_m varchar2(150)
357: ,pgp_segment28 pay_people_groups.segment28%type
358: ,pgp_segment28_v varchar2(150)
359: ,pgp_segment28_m varchar2(150)
360: ,pgp_segment29 pay_people_groups.segment29%type
361: ,pgp_segment29_v varchar2(150)

Line 360: ,pgp_segment29 pay_people_groups.segment29%type

356: ,pgp_segment27_m varchar2(150)
357: ,pgp_segment28 pay_people_groups.segment28%type
358: ,pgp_segment28_v varchar2(150)
359: ,pgp_segment28_m varchar2(150)
360: ,pgp_segment29 pay_people_groups.segment29%type
361: ,pgp_segment29_v varchar2(150)
362: ,pgp_segment29_m varchar2(150)
363: ,pgp_segment30 pay_people_groups.segment30%type
364: ,pgp_segment30_v varchar2(150)

Line 363: ,pgp_segment30 pay_people_groups.segment30%type

359: ,pgp_segment28_m varchar2(150)
360: ,pgp_segment29 pay_people_groups.segment29%type
361: ,pgp_segment29_v varchar2(150)
362: ,pgp_segment29_m varchar2(150)
363: ,pgp_segment30 pay_people_groups.segment30%type
364: ,pgp_segment30_v varchar2(150)
365: ,pgp_segment30_m varchar2(150)
366: ,people_group_id per_all_assignments_f.people_group_id%type
367: ,scl_segment1 hr_soft_coding_keyflex.segment1%type

Line 657: ,people_group pay_people_groups.group_name%type default null

653: ,recruitment_activity per_recruitment_activities.name%type default null
654: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type default null
655: ,organization hr_all_organization_units.name%type default null
656: ,organization_id per_all_assignments_f.organization_id%type default null
657: ,people_group pay_people_groups.group_name%type default null
658: ,people_group_id per_all_assignments_f.people_group_id%type default null
659: ,vacancy per_vacancies.name%type default null
660: ,vacancy_id per_all_assignments_f.vacancy_id%type default null
661: ,requisition per_requisitions.name%type default null

Line 761: ,people_group in pay_people_groups.group_name%type default null

757: ,recruitment_activity in per_recruitment_activities.name%type default null
758: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
759: ,organization in hr_all_organization_units.name%type default null
760: ,organization_id in per_all_assignments_f.organization_id%type default null
761: ,people_group in pay_people_groups.group_name%type default null
762: ,people_group_id in per_all_assignments_f.people_group_id%type default null
763: ,vacancy in per_vacancies.name%type default null
764: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
765: ,requisition in per_requisitions.name%type default null