DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PAY_PEOPLE_GROUPS

Line 212: ,pgp_segment1 pay_people_groups.segment1%type

208: ,source_organization hr_all_organization_units.name%type
209: ,source_organization_id per_all_assignments_f.source_organization_id%type
210: ,organization hr_all_organization_units.name%type
211: ,organization_id per_all_assignments_f.organization_id%type
212: ,pgp_segment1 pay_people_groups.segment1%type
213: ,pgp_segment2 pay_people_groups.segment2%type
214: ,pgp_segment3 pay_people_groups.segment3%type
215: ,pgp_segment4 pay_people_groups.segment4%type
216: ,pgp_segment5 pay_people_groups.segment5%type

Line 213: ,pgp_segment2 pay_people_groups.segment2%type

209: ,source_organization_id per_all_assignments_f.source_organization_id%type
210: ,organization hr_all_organization_units.name%type
211: ,organization_id per_all_assignments_f.organization_id%type
212: ,pgp_segment1 pay_people_groups.segment1%type
213: ,pgp_segment2 pay_people_groups.segment2%type
214: ,pgp_segment3 pay_people_groups.segment3%type
215: ,pgp_segment4 pay_people_groups.segment4%type
216: ,pgp_segment5 pay_people_groups.segment5%type
217: ,pgp_segment6 pay_people_groups.segment6%type

Line 214: ,pgp_segment3 pay_people_groups.segment3%type

210: ,organization hr_all_organization_units.name%type
211: ,organization_id per_all_assignments_f.organization_id%type
212: ,pgp_segment1 pay_people_groups.segment1%type
213: ,pgp_segment2 pay_people_groups.segment2%type
214: ,pgp_segment3 pay_people_groups.segment3%type
215: ,pgp_segment4 pay_people_groups.segment4%type
216: ,pgp_segment5 pay_people_groups.segment5%type
217: ,pgp_segment6 pay_people_groups.segment6%type
218: ,pgp_segment7 pay_people_groups.segment7%type

Line 215: ,pgp_segment4 pay_people_groups.segment4%type

211: ,organization_id per_all_assignments_f.organization_id%type
212: ,pgp_segment1 pay_people_groups.segment1%type
213: ,pgp_segment2 pay_people_groups.segment2%type
214: ,pgp_segment3 pay_people_groups.segment3%type
215: ,pgp_segment4 pay_people_groups.segment4%type
216: ,pgp_segment5 pay_people_groups.segment5%type
217: ,pgp_segment6 pay_people_groups.segment6%type
218: ,pgp_segment7 pay_people_groups.segment7%type
219: ,pgp_segment8 pay_people_groups.segment8%type

Line 216: ,pgp_segment5 pay_people_groups.segment5%type

212: ,pgp_segment1 pay_people_groups.segment1%type
213: ,pgp_segment2 pay_people_groups.segment2%type
214: ,pgp_segment3 pay_people_groups.segment3%type
215: ,pgp_segment4 pay_people_groups.segment4%type
216: ,pgp_segment5 pay_people_groups.segment5%type
217: ,pgp_segment6 pay_people_groups.segment6%type
218: ,pgp_segment7 pay_people_groups.segment7%type
219: ,pgp_segment8 pay_people_groups.segment8%type
220: ,pgp_segment9 pay_people_groups.segment9%type

Line 217: ,pgp_segment6 pay_people_groups.segment6%type

213: ,pgp_segment2 pay_people_groups.segment2%type
214: ,pgp_segment3 pay_people_groups.segment3%type
215: ,pgp_segment4 pay_people_groups.segment4%type
216: ,pgp_segment5 pay_people_groups.segment5%type
217: ,pgp_segment6 pay_people_groups.segment6%type
218: ,pgp_segment7 pay_people_groups.segment7%type
219: ,pgp_segment8 pay_people_groups.segment8%type
220: ,pgp_segment9 pay_people_groups.segment9%type
221: ,pgp_segment10 pay_people_groups.segment10%type

Line 218: ,pgp_segment7 pay_people_groups.segment7%type

214: ,pgp_segment3 pay_people_groups.segment3%type
215: ,pgp_segment4 pay_people_groups.segment4%type
216: ,pgp_segment5 pay_people_groups.segment5%type
217: ,pgp_segment6 pay_people_groups.segment6%type
218: ,pgp_segment7 pay_people_groups.segment7%type
219: ,pgp_segment8 pay_people_groups.segment8%type
220: ,pgp_segment9 pay_people_groups.segment9%type
221: ,pgp_segment10 pay_people_groups.segment10%type
222: ,pgp_segment11 pay_people_groups.segment11%type

Line 219: ,pgp_segment8 pay_people_groups.segment8%type

215: ,pgp_segment4 pay_people_groups.segment4%type
216: ,pgp_segment5 pay_people_groups.segment5%type
217: ,pgp_segment6 pay_people_groups.segment6%type
218: ,pgp_segment7 pay_people_groups.segment7%type
219: ,pgp_segment8 pay_people_groups.segment8%type
220: ,pgp_segment9 pay_people_groups.segment9%type
221: ,pgp_segment10 pay_people_groups.segment10%type
222: ,pgp_segment11 pay_people_groups.segment11%type
223: ,pgp_segment12 pay_people_groups.segment12%type

Line 220: ,pgp_segment9 pay_people_groups.segment9%type

216: ,pgp_segment5 pay_people_groups.segment5%type
217: ,pgp_segment6 pay_people_groups.segment6%type
218: ,pgp_segment7 pay_people_groups.segment7%type
219: ,pgp_segment8 pay_people_groups.segment8%type
220: ,pgp_segment9 pay_people_groups.segment9%type
221: ,pgp_segment10 pay_people_groups.segment10%type
222: ,pgp_segment11 pay_people_groups.segment11%type
223: ,pgp_segment12 pay_people_groups.segment12%type
224: ,pgp_segment13 pay_people_groups.segment13%type

Line 221: ,pgp_segment10 pay_people_groups.segment10%type

217: ,pgp_segment6 pay_people_groups.segment6%type
218: ,pgp_segment7 pay_people_groups.segment7%type
219: ,pgp_segment8 pay_people_groups.segment8%type
220: ,pgp_segment9 pay_people_groups.segment9%type
221: ,pgp_segment10 pay_people_groups.segment10%type
222: ,pgp_segment11 pay_people_groups.segment11%type
223: ,pgp_segment12 pay_people_groups.segment12%type
224: ,pgp_segment13 pay_people_groups.segment13%type
225: ,pgp_segment14 pay_people_groups.segment14%type

Line 222: ,pgp_segment11 pay_people_groups.segment11%type

218: ,pgp_segment7 pay_people_groups.segment7%type
219: ,pgp_segment8 pay_people_groups.segment8%type
220: ,pgp_segment9 pay_people_groups.segment9%type
221: ,pgp_segment10 pay_people_groups.segment10%type
222: ,pgp_segment11 pay_people_groups.segment11%type
223: ,pgp_segment12 pay_people_groups.segment12%type
224: ,pgp_segment13 pay_people_groups.segment13%type
225: ,pgp_segment14 pay_people_groups.segment14%type
226: ,pgp_segment15 pay_people_groups.segment15%type

Line 223: ,pgp_segment12 pay_people_groups.segment12%type

219: ,pgp_segment8 pay_people_groups.segment8%type
220: ,pgp_segment9 pay_people_groups.segment9%type
221: ,pgp_segment10 pay_people_groups.segment10%type
222: ,pgp_segment11 pay_people_groups.segment11%type
223: ,pgp_segment12 pay_people_groups.segment12%type
224: ,pgp_segment13 pay_people_groups.segment13%type
225: ,pgp_segment14 pay_people_groups.segment14%type
226: ,pgp_segment15 pay_people_groups.segment15%type
227: ,pgp_segment16 pay_people_groups.segment16%type

Line 224: ,pgp_segment13 pay_people_groups.segment13%type

220: ,pgp_segment9 pay_people_groups.segment9%type
221: ,pgp_segment10 pay_people_groups.segment10%type
222: ,pgp_segment11 pay_people_groups.segment11%type
223: ,pgp_segment12 pay_people_groups.segment12%type
224: ,pgp_segment13 pay_people_groups.segment13%type
225: ,pgp_segment14 pay_people_groups.segment14%type
226: ,pgp_segment15 pay_people_groups.segment15%type
227: ,pgp_segment16 pay_people_groups.segment16%type
228: ,pgp_segment17 pay_people_groups.segment17%type

Line 225: ,pgp_segment14 pay_people_groups.segment14%type

221: ,pgp_segment10 pay_people_groups.segment10%type
222: ,pgp_segment11 pay_people_groups.segment11%type
223: ,pgp_segment12 pay_people_groups.segment12%type
224: ,pgp_segment13 pay_people_groups.segment13%type
225: ,pgp_segment14 pay_people_groups.segment14%type
226: ,pgp_segment15 pay_people_groups.segment15%type
227: ,pgp_segment16 pay_people_groups.segment16%type
228: ,pgp_segment17 pay_people_groups.segment17%type
229: ,pgp_segment18 pay_people_groups.segment18%type

Line 226: ,pgp_segment15 pay_people_groups.segment15%type

222: ,pgp_segment11 pay_people_groups.segment11%type
223: ,pgp_segment12 pay_people_groups.segment12%type
224: ,pgp_segment13 pay_people_groups.segment13%type
225: ,pgp_segment14 pay_people_groups.segment14%type
226: ,pgp_segment15 pay_people_groups.segment15%type
227: ,pgp_segment16 pay_people_groups.segment16%type
228: ,pgp_segment17 pay_people_groups.segment17%type
229: ,pgp_segment18 pay_people_groups.segment18%type
230: ,pgp_segment19 pay_people_groups.segment19%type

Line 227: ,pgp_segment16 pay_people_groups.segment16%type

223: ,pgp_segment12 pay_people_groups.segment12%type
224: ,pgp_segment13 pay_people_groups.segment13%type
225: ,pgp_segment14 pay_people_groups.segment14%type
226: ,pgp_segment15 pay_people_groups.segment15%type
227: ,pgp_segment16 pay_people_groups.segment16%type
228: ,pgp_segment17 pay_people_groups.segment17%type
229: ,pgp_segment18 pay_people_groups.segment18%type
230: ,pgp_segment19 pay_people_groups.segment19%type
231: ,pgp_segment20 pay_people_groups.segment20%type

Line 228: ,pgp_segment17 pay_people_groups.segment17%type

224: ,pgp_segment13 pay_people_groups.segment13%type
225: ,pgp_segment14 pay_people_groups.segment14%type
226: ,pgp_segment15 pay_people_groups.segment15%type
227: ,pgp_segment16 pay_people_groups.segment16%type
228: ,pgp_segment17 pay_people_groups.segment17%type
229: ,pgp_segment18 pay_people_groups.segment18%type
230: ,pgp_segment19 pay_people_groups.segment19%type
231: ,pgp_segment20 pay_people_groups.segment20%type
232: ,pgp_segment21 pay_people_groups.segment21%type

Line 229: ,pgp_segment18 pay_people_groups.segment18%type

225: ,pgp_segment14 pay_people_groups.segment14%type
226: ,pgp_segment15 pay_people_groups.segment15%type
227: ,pgp_segment16 pay_people_groups.segment16%type
228: ,pgp_segment17 pay_people_groups.segment17%type
229: ,pgp_segment18 pay_people_groups.segment18%type
230: ,pgp_segment19 pay_people_groups.segment19%type
231: ,pgp_segment20 pay_people_groups.segment20%type
232: ,pgp_segment21 pay_people_groups.segment21%type
233: ,pgp_segment22 pay_people_groups.segment22%type

Line 230: ,pgp_segment19 pay_people_groups.segment19%type

226: ,pgp_segment15 pay_people_groups.segment15%type
227: ,pgp_segment16 pay_people_groups.segment16%type
228: ,pgp_segment17 pay_people_groups.segment17%type
229: ,pgp_segment18 pay_people_groups.segment18%type
230: ,pgp_segment19 pay_people_groups.segment19%type
231: ,pgp_segment20 pay_people_groups.segment20%type
232: ,pgp_segment21 pay_people_groups.segment21%type
233: ,pgp_segment22 pay_people_groups.segment22%type
234: ,pgp_segment23 pay_people_groups.segment23%type

Line 231: ,pgp_segment20 pay_people_groups.segment20%type

227: ,pgp_segment16 pay_people_groups.segment16%type
228: ,pgp_segment17 pay_people_groups.segment17%type
229: ,pgp_segment18 pay_people_groups.segment18%type
230: ,pgp_segment19 pay_people_groups.segment19%type
231: ,pgp_segment20 pay_people_groups.segment20%type
232: ,pgp_segment21 pay_people_groups.segment21%type
233: ,pgp_segment22 pay_people_groups.segment22%type
234: ,pgp_segment23 pay_people_groups.segment23%type
235: ,pgp_segment24 pay_people_groups.segment24%type

Line 232: ,pgp_segment21 pay_people_groups.segment21%type

228: ,pgp_segment17 pay_people_groups.segment17%type
229: ,pgp_segment18 pay_people_groups.segment18%type
230: ,pgp_segment19 pay_people_groups.segment19%type
231: ,pgp_segment20 pay_people_groups.segment20%type
232: ,pgp_segment21 pay_people_groups.segment21%type
233: ,pgp_segment22 pay_people_groups.segment22%type
234: ,pgp_segment23 pay_people_groups.segment23%type
235: ,pgp_segment24 pay_people_groups.segment24%type
236: ,pgp_segment25 pay_people_groups.segment25%type

Line 233: ,pgp_segment22 pay_people_groups.segment22%type

229: ,pgp_segment18 pay_people_groups.segment18%type
230: ,pgp_segment19 pay_people_groups.segment19%type
231: ,pgp_segment20 pay_people_groups.segment20%type
232: ,pgp_segment21 pay_people_groups.segment21%type
233: ,pgp_segment22 pay_people_groups.segment22%type
234: ,pgp_segment23 pay_people_groups.segment23%type
235: ,pgp_segment24 pay_people_groups.segment24%type
236: ,pgp_segment25 pay_people_groups.segment25%type
237: ,pgp_segment26 pay_people_groups.segment26%type

Line 234: ,pgp_segment23 pay_people_groups.segment23%type

230: ,pgp_segment19 pay_people_groups.segment19%type
231: ,pgp_segment20 pay_people_groups.segment20%type
232: ,pgp_segment21 pay_people_groups.segment21%type
233: ,pgp_segment22 pay_people_groups.segment22%type
234: ,pgp_segment23 pay_people_groups.segment23%type
235: ,pgp_segment24 pay_people_groups.segment24%type
236: ,pgp_segment25 pay_people_groups.segment25%type
237: ,pgp_segment26 pay_people_groups.segment26%type
238: ,pgp_segment27 pay_people_groups.segment27%type

Line 235: ,pgp_segment24 pay_people_groups.segment24%type

231: ,pgp_segment20 pay_people_groups.segment20%type
232: ,pgp_segment21 pay_people_groups.segment21%type
233: ,pgp_segment22 pay_people_groups.segment22%type
234: ,pgp_segment23 pay_people_groups.segment23%type
235: ,pgp_segment24 pay_people_groups.segment24%type
236: ,pgp_segment25 pay_people_groups.segment25%type
237: ,pgp_segment26 pay_people_groups.segment26%type
238: ,pgp_segment27 pay_people_groups.segment27%type
239: ,pgp_segment28 pay_people_groups.segment28%type

Line 236: ,pgp_segment25 pay_people_groups.segment25%type

232: ,pgp_segment21 pay_people_groups.segment21%type
233: ,pgp_segment22 pay_people_groups.segment22%type
234: ,pgp_segment23 pay_people_groups.segment23%type
235: ,pgp_segment24 pay_people_groups.segment24%type
236: ,pgp_segment25 pay_people_groups.segment25%type
237: ,pgp_segment26 pay_people_groups.segment26%type
238: ,pgp_segment27 pay_people_groups.segment27%type
239: ,pgp_segment28 pay_people_groups.segment28%type
240: ,pgp_segment29 pay_people_groups.segment29%type

Line 237: ,pgp_segment26 pay_people_groups.segment26%type

233: ,pgp_segment22 pay_people_groups.segment22%type
234: ,pgp_segment23 pay_people_groups.segment23%type
235: ,pgp_segment24 pay_people_groups.segment24%type
236: ,pgp_segment25 pay_people_groups.segment25%type
237: ,pgp_segment26 pay_people_groups.segment26%type
238: ,pgp_segment27 pay_people_groups.segment27%type
239: ,pgp_segment28 pay_people_groups.segment28%type
240: ,pgp_segment29 pay_people_groups.segment29%type
241: ,pgp_segment30 pay_people_groups.segment30%type

Line 238: ,pgp_segment27 pay_people_groups.segment27%type

234: ,pgp_segment23 pay_people_groups.segment23%type
235: ,pgp_segment24 pay_people_groups.segment24%type
236: ,pgp_segment25 pay_people_groups.segment25%type
237: ,pgp_segment26 pay_people_groups.segment26%type
238: ,pgp_segment27 pay_people_groups.segment27%type
239: ,pgp_segment28 pay_people_groups.segment28%type
240: ,pgp_segment29 pay_people_groups.segment29%type
241: ,pgp_segment30 pay_people_groups.segment30%type
242: ,people_group_id per_all_assignments_f.people_group_id%type

Line 239: ,pgp_segment28 pay_people_groups.segment28%type

235: ,pgp_segment24 pay_people_groups.segment24%type
236: ,pgp_segment25 pay_people_groups.segment25%type
237: ,pgp_segment26 pay_people_groups.segment26%type
238: ,pgp_segment27 pay_people_groups.segment27%type
239: ,pgp_segment28 pay_people_groups.segment28%type
240: ,pgp_segment29 pay_people_groups.segment29%type
241: ,pgp_segment30 pay_people_groups.segment30%type
242: ,people_group_id per_all_assignments_f.people_group_id%type
243: ,scl_segment1 hr_soft_coding_keyflex.segment1%type

Line 240: ,pgp_segment29 pay_people_groups.segment29%type

236: ,pgp_segment25 pay_people_groups.segment25%type
237: ,pgp_segment26 pay_people_groups.segment26%type
238: ,pgp_segment27 pay_people_groups.segment27%type
239: ,pgp_segment28 pay_people_groups.segment28%type
240: ,pgp_segment29 pay_people_groups.segment29%type
241: ,pgp_segment30 pay_people_groups.segment30%type
242: ,people_group_id per_all_assignments_f.people_group_id%type
243: ,scl_segment1 hr_soft_coding_keyflex.segment1%type
244: ,scl_segment2 hr_soft_coding_keyflex.segment2%type

Line 241: ,pgp_segment30 pay_people_groups.segment30%type

237: ,pgp_segment26 pay_people_groups.segment26%type
238: ,pgp_segment27 pay_people_groups.segment27%type
239: ,pgp_segment28 pay_people_groups.segment28%type
240: ,pgp_segment29 pay_people_groups.segment29%type
241: ,pgp_segment30 pay_people_groups.segment30%type
242: ,people_group_id per_all_assignments_f.people_group_id%type
243: ,scl_segment1 hr_soft_coding_keyflex.segment1%type
244: ,scl_segment2 hr_soft_coding_keyflex.segment2%type
245: ,scl_segment3 hr_soft_coding_keyflex.segment3%type