APPS.PER_QH_SUMMARY_QUERY dependencies on PAY_PEOPLE_GROUPS

Line 160: ,pgp_segment1 pay_people_groups.segment1%type

156: ,supervisor per_all_people_f.full_name%type
157: ,recruitment_activity per_recruitment_activities.name%type
158: ,source_organization hr_all_organization_units.name%type
159: ,organization hr_all_organization_units.name%type
160: ,pgp_segment1 pay_people_groups.segment1%type
161: ,pgp_segment2 pay_people_groups.segment2%type
162: ,pgp_segment3 pay_people_groups.segment3%type
163: ,pgp_segment4 pay_people_groups.segment4%type
164: ,pgp_segment5 pay_people_groups.segment5%type

Line 161: ,pgp_segment2 pay_people_groups.segment2%type

157: ,recruitment_activity per_recruitment_activities.name%type
158: ,source_organization hr_all_organization_units.name%type
159: ,organization hr_all_organization_units.name%type
160: ,pgp_segment1 pay_people_groups.segment1%type
161: ,pgp_segment2 pay_people_groups.segment2%type
162: ,pgp_segment3 pay_people_groups.segment3%type
163: ,pgp_segment4 pay_people_groups.segment4%type
164: ,pgp_segment5 pay_people_groups.segment5%type
165: ,pgp_segment6 pay_people_groups.segment6%type

Line 162: ,pgp_segment3 pay_people_groups.segment3%type

158: ,source_organization hr_all_organization_units.name%type
159: ,organization hr_all_organization_units.name%type
160: ,pgp_segment1 pay_people_groups.segment1%type
161: ,pgp_segment2 pay_people_groups.segment2%type
162: ,pgp_segment3 pay_people_groups.segment3%type
163: ,pgp_segment4 pay_people_groups.segment4%type
164: ,pgp_segment5 pay_people_groups.segment5%type
165: ,pgp_segment6 pay_people_groups.segment6%type
166: ,pgp_segment7 pay_people_groups.segment7%type

Line 163: ,pgp_segment4 pay_people_groups.segment4%type

159: ,organization hr_all_organization_units.name%type
160: ,pgp_segment1 pay_people_groups.segment1%type
161: ,pgp_segment2 pay_people_groups.segment2%type
162: ,pgp_segment3 pay_people_groups.segment3%type
163: ,pgp_segment4 pay_people_groups.segment4%type
164: ,pgp_segment5 pay_people_groups.segment5%type
165: ,pgp_segment6 pay_people_groups.segment6%type
166: ,pgp_segment7 pay_people_groups.segment7%type
167: ,pgp_segment8 pay_people_groups.segment8%type

Line 164: ,pgp_segment5 pay_people_groups.segment5%type

160: ,pgp_segment1 pay_people_groups.segment1%type
161: ,pgp_segment2 pay_people_groups.segment2%type
162: ,pgp_segment3 pay_people_groups.segment3%type
163: ,pgp_segment4 pay_people_groups.segment4%type
164: ,pgp_segment5 pay_people_groups.segment5%type
165: ,pgp_segment6 pay_people_groups.segment6%type
166: ,pgp_segment7 pay_people_groups.segment7%type
167: ,pgp_segment8 pay_people_groups.segment8%type
168: ,pgp_segment9 pay_people_groups.segment9%type

Line 165: ,pgp_segment6 pay_people_groups.segment6%type

161: ,pgp_segment2 pay_people_groups.segment2%type
162: ,pgp_segment3 pay_people_groups.segment3%type
163: ,pgp_segment4 pay_people_groups.segment4%type
164: ,pgp_segment5 pay_people_groups.segment5%type
165: ,pgp_segment6 pay_people_groups.segment6%type
166: ,pgp_segment7 pay_people_groups.segment7%type
167: ,pgp_segment8 pay_people_groups.segment8%type
168: ,pgp_segment9 pay_people_groups.segment9%type
169: ,pgp_segment10 pay_people_groups.segment10%type

Line 166: ,pgp_segment7 pay_people_groups.segment7%type

162: ,pgp_segment3 pay_people_groups.segment3%type
163: ,pgp_segment4 pay_people_groups.segment4%type
164: ,pgp_segment5 pay_people_groups.segment5%type
165: ,pgp_segment6 pay_people_groups.segment6%type
166: ,pgp_segment7 pay_people_groups.segment7%type
167: ,pgp_segment8 pay_people_groups.segment8%type
168: ,pgp_segment9 pay_people_groups.segment9%type
169: ,pgp_segment10 pay_people_groups.segment10%type
170: ,pgp_segment11 pay_people_groups.segment11%type

Line 167: ,pgp_segment8 pay_people_groups.segment8%type

163: ,pgp_segment4 pay_people_groups.segment4%type
164: ,pgp_segment5 pay_people_groups.segment5%type
165: ,pgp_segment6 pay_people_groups.segment6%type
166: ,pgp_segment7 pay_people_groups.segment7%type
167: ,pgp_segment8 pay_people_groups.segment8%type
168: ,pgp_segment9 pay_people_groups.segment9%type
169: ,pgp_segment10 pay_people_groups.segment10%type
170: ,pgp_segment11 pay_people_groups.segment11%type
171: ,pgp_segment12 pay_people_groups.segment12%type

Line 168: ,pgp_segment9 pay_people_groups.segment9%type

164: ,pgp_segment5 pay_people_groups.segment5%type
165: ,pgp_segment6 pay_people_groups.segment6%type
166: ,pgp_segment7 pay_people_groups.segment7%type
167: ,pgp_segment8 pay_people_groups.segment8%type
168: ,pgp_segment9 pay_people_groups.segment9%type
169: ,pgp_segment10 pay_people_groups.segment10%type
170: ,pgp_segment11 pay_people_groups.segment11%type
171: ,pgp_segment12 pay_people_groups.segment12%type
172: ,pgp_segment13 pay_people_groups.segment13%type

Line 169: ,pgp_segment10 pay_people_groups.segment10%type

165: ,pgp_segment6 pay_people_groups.segment6%type
166: ,pgp_segment7 pay_people_groups.segment7%type
167: ,pgp_segment8 pay_people_groups.segment8%type
168: ,pgp_segment9 pay_people_groups.segment9%type
169: ,pgp_segment10 pay_people_groups.segment10%type
170: ,pgp_segment11 pay_people_groups.segment11%type
171: ,pgp_segment12 pay_people_groups.segment12%type
172: ,pgp_segment13 pay_people_groups.segment13%type
173: ,pgp_segment14 pay_people_groups.segment14%type

Line 170: ,pgp_segment11 pay_people_groups.segment11%type

166: ,pgp_segment7 pay_people_groups.segment7%type
167: ,pgp_segment8 pay_people_groups.segment8%type
168: ,pgp_segment9 pay_people_groups.segment9%type
169: ,pgp_segment10 pay_people_groups.segment10%type
170: ,pgp_segment11 pay_people_groups.segment11%type
171: ,pgp_segment12 pay_people_groups.segment12%type
172: ,pgp_segment13 pay_people_groups.segment13%type
173: ,pgp_segment14 pay_people_groups.segment14%type
174: ,pgp_segment15 pay_people_groups.segment15%type

Line 171: ,pgp_segment12 pay_people_groups.segment12%type

167: ,pgp_segment8 pay_people_groups.segment8%type
168: ,pgp_segment9 pay_people_groups.segment9%type
169: ,pgp_segment10 pay_people_groups.segment10%type
170: ,pgp_segment11 pay_people_groups.segment11%type
171: ,pgp_segment12 pay_people_groups.segment12%type
172: ,pgp_segment13 pay_people_groups.segment13%type
173: ,pgp_segment14 pay_people_groups.segment14%type
174: ,pgp_segment15 pay_people_groups.segment15%type
175: ,pgp_segment16 pay_people_groups.segment16%type

Line 172: ,pgp_segment13 pay_people_groups.segment13%type

168: ,pgp_segment9 pay_people_groups.segment9%type
169: ,pgp_segment10 pay_people_groups.segment10%type
170: ,pgp_segment11 pay_people_groups.segment11%type
171: ,pgp_segment12 pay_people_groups.segment12%type
172: ,pgp_segment13 pay_people_groups.segment13%type
173: ,pgp_segment14 pay_people_groups.segment14%type
174: ,pgp_segment15 pay_people_groups.segment15%type
175: ,pgp_segment16 pay_people_groups.segment16%type
176: ,pgp_segment17 pay_people_groups.segment17%type

Line 173: ,pgp_segment14 pay_people_groups.segment14%type

169: ,pgp_segment10 pay_people_groups.segment10%type
170: ,pgp_segment11 pay_people_groups.segment11%type
171: ,pgp_segment12 pay_people_groups.segment12%type
172: ,pgp_segment13 pay_people_groups.segment13%type
173: ,pgp_segment14 pay_people_groups.segment14%type
174: ,pgp_segment15 pay_people_groups.segment15%type
175: ,pgp_segment16 pay_people_groups.segment16%type
176: ,pgp_segment17 pay_people_groups.segment17%type
177: ,pgp_segment18 pay_people_groups.segment18%type

Line 174: ,pgp_segment15 pay_people_groups.segment15%type

170: ,pgp_segment11 pay_people_groups.segment11%type
171: ,pgp_segment12 pay_people_groups.segment12%type
172: ,pgp_segment13 pay_people_groups.segment13%type
173: ,pgp_segment14 pay_people_groups.segment14%type
174: ,pgp_segment15 pay_people_groups.segment15%type
175: ,pgp_segment16 pay_people_groups.segment16%type
176: ,pgp_segment17 pay_people_groups.segment17%type
177: ,pgp_segment18 pay_people_groups.segment18%type
178: ,pgp_segment19 pay_people_groups.segment19%type

Line 175: ,pgp_segment16 pay_people_groups.segment16%type

171: ,pgp_segment12 pay_people_groups.segment12%type
172: ,pgp_segment13 pay_people_groups.segment13%type
173: ,pgp_segment14 pay_people_groups.segment14%type
174: ,pgp_segment15 pay_people_groups.segment15%type
175: ,pgp_segment16 pay_people_groups.segment16%type
176: ,pgp_segment17 pay_people_groups.segment17%type
177: ,pgp_segment18 pay_people_groups.segment18%type
178: ,pgp_segment19 pay_people_groups.segment19%type
179: ,pgp_segment20 pay_people_groups.segment20%type

Line 176: ,pgp_segment17 pay_people_groups.segment17%type

172: ,pgp_segment13 pay_people_groups.segment13%type
173: ,pgp_segment14 pay_people_groups.segment14%type
174: ,pgp_segment15 pay_people_groups.segment15%type
175: ,pgp_segment16 pay_people_groups.segment16%type
176: ,pgp_segment17 pay_people_groups.segment17%type
177: ,pgp_segment18 pay_people_groups.segment18%type
178: ,pgp_segment19 pay_people_groups.segment19%type
179: ,pgp_segment20 pay_people_groups.segment20%type
180: ,pgp_segment21 pay_people_groups.segment21%type

Line 177: ,pgp_segment18 pay_people_groups.segment18%type

173: ,pgp_segment14 pay_people_groups.segment14%type
174: ,pgp_segment15 pay_people_groups.segment15%type
175: ,pgp_segment16 pay_people_groups.segment16%type
176: ,pgp_segment17 pay_people_groups.segment17%type
177: ,pgp_segment18 pay_people_groups.segment18%type
178: ,pgp_segment19 pay_people_groups.segment19%type
179: ,pgp_segment20 pay_people_groups.segment20%type
180: ,pgp_segment21 pay_people_groups.segment21%type
181: ,pgp_segment22 pay_people_groups.segment22%type

Line 178: ,pgp_segment19 pay_people_groups.segment19%type

174: ,pgp_segment15 pay_people_groups.segment15%type
175: ,pgp_segment16 pay_people_groups.segment16%type
176: ,pgp_segment17 pay_people_groups.segment17%type
177: ,pgp_segment18 pay_people_groups.segment18%type
178: ,pgp_segment19 pay_people_groups.segment19%type
179: ,pgp_segment20 pay_people_groups.segment20%type
180: ,pgp_segment21 pay_people_groups.segment21%type
181: ,pgp_segment22 pay_people_groups.segment22%type
182: ,pgp_segment23 pay_people_groups.segment23%type

Line 179: ,pgp_segment20 pay_people_groups.segment20%type

175: ,pgp_segment16 pay_people_groups.segment16%type
176: ,pgp_segment17 pay_people_groups.segment17%type
177: ,pgp_segment18 pay_people_groups.segment18%type
178: ,pgp_segment19 pay_people_groups.segment19%type
179: ,pgp_segment20 pay_people_groups.segment20%type
180: ,pgp_segment21 pay_people_groups.segment21%type
181: ,pgp_segment22 pay_people_groups.segment22%type
182: ,pgp_segment23 pay_people_groups.segment23%type
183: ,pgp_segment24 pay_people_groups.segment24%type

Line 180: ,pgp_segment21 pay_people_groups.segment21%type

176: ,pgp_segment17 pay_people_groups.segment17%type
177: ,pgp_segment18 pay_people_groups.segment18%type
178: ,pgp_segment19 pay_people_groups.segment19%type
179: ,pgp_segment20 pay_people_groups.segment20%type
180: ,pgp_segment21 pay_people_groups.segment21%type
181: ,pgp_segment22 pay_people_groups.segment22%type
182: ,pgp_segment23 pay_people_groups.segment23%type
183: ,pgp_segment24 pay_people_groups.segment24%type
184: ,pgp_segment25 pay_people_groups.segment25%type

Line 181: ,pgp_segment22 pay_people_groups.segment22%type

177: ,pgp_segment18 pay_people_groups.segment18%type
178: ,pgp_segment19 pay_people_groups.segment19%type
179: ,pgp_segment20 pay_people_groups.segment20%type
180: ,pgp_segment21 pay_people_groups.segment21%type
181: ,pgp_segment22 pay_people_groups.segment22%type
182: ,pgp_segment23 pay_people_groups.segment23%type
183: ,pgp_segment24 pay_people_groups.segment24%type
184: ,pgp_segment25 pay_people_groups.segment25%type
185: ,pgp_segment26 pay_people_groups.segment26%type

Line 182: ,pgp_segment23 pay_people_groups.segment23%type

178: ,pgp_segment19 pay_people_groups.segment19%type
179: ,pgp_segment20 pay_people_groups.segment20%type
180: ,pgp_segment21 pay_people_groups.segment21%type
181: ,pgp_segment22 pay_people_groups.segment22%type
182: ,pgp_segment23 pay_people_groups.segment23%type
183: ,pgp_segment24 pay_people_groups.segment24%type
184: ,pgp_segment25 pay_people_groups.segment25%type
185: ,pgp_segment26 pay_people_groups.segment26%type
186: ,pgp_segment27 pay_people_groups.segment27%type

Line 183: ,pgp_segment24 pay_people_groups.segment24%type

179: ,pgp_segment20 pay_people_groups.segment20%type
180: ,pgp_segment21 pay_people_groups.segment21%type
181: ,pgp_segment22 pay_people_groups.segment22%type
182: ,pgp_segment23 pay_people_groups.segment23%type
183: ,pgp_segment24 pay_people_groups.segment24%type
184: ,pgp_segment25 pay_people_groups.segment25%type
185: ,pgp_segment26 pay_people_groups.segment26%type
186: ,pgp_segment27 pay_people_groups.segment27%type
187: ,pgp_segment28 pay_people_groups.segment28%type

Line 184: ,pgp_segment25 pay_people_groups.segment25%type

180: ,pgp_segment21 pay_people_groups.segment21%type
181: ,pgp_segment22 pay_people_groups.segment22%type
182: ,pgp_segment23 pay_people_groups.segment23%type
183: ,pgp_segment24 pay_people_groups.segment24%type
184: ,pgp_segment25 pay_people_groups.segment25%type
185: ,pgp_segment26 pay_people_groups.segment26%type
186: ,pgp_segment27 pay_people_groups.segment27%type
187: ,pgp_segment28 pay_people_groups.segment28%type
188: ,pgp_segment29 pay_people_groups.segment29%type

Line 185: ,pgp_segment26 pay_people_groups.segment26%type

181: ,pgp_segment22 pay_people_groups.segment22%type
182: ,pgp_segment23 pay_people_groups.segment23%type
183: ,pgp_segment24 pay_people_groups.segment24%type
184: ,pgp_segment25 pay_people_groups.segment25%type
185: ,pgp_segment26 pay_people_groups.segment26%type
186: ,pgp_segment27 pay_people_groups.segment27%type
187: ,pgp_segment28 pay_people_groups.segment28%type
188: ,pgp_segment29 pay_people_groups.segment29%type
189: ,pgp_segment30 pay_people_groups.segment30%type

Line 186: ,pgp_segment27 pay_people_groups.segment27%type

182: ,pgp_segment23 pay_people_groups.segment23%type
183: ,pgp_segment24 pay_people_groups.segment24%type
184: ,pgp_segment25 pay_people_groups.segment25%type
185: ,pgp_segment26 pay_people_groups.segment26%type
186: ,pgp_segment27 pay_people_groups.segment27%type
187: ,pgp_segment28 pay_people_groups.segment28%type
188: ,pgp_segment29 pay_people_groups.segment29%type
189: ,pgp_segment30 pay_people_groups.segment30%type
190: ,people_group_id per_all_assignments_f.people_group_id%type

Line 187: ,pgp_segment28 pay_people_groups.segment28%type

183: ,pgp_segment24 pay_people_groups.segment24%type
184: ,pgp_segment25 pay_people_groups.segment25%type
185: ,pgp_segment26 pay_people_groups.segment26%type
186: ,pgp_segment27 pay_people_groups.segment27%type
187: ,pgp_segment28 pay_people_groups.segment28%type
188: ,pgp_segment29 pay_people_groups.segment29%type
189: ,pgp_segment30 pay_people_groups.segment30%type
190: ,people_group_id per_all_assignments_f.people_group_id%type
191: ,scl_segment1 hr_soft_coding_keyflex.segment1%type

Line 188: ,pgp_segment29 pay_people_groups.segment29%type

184: ,pgp_segment25 pay_people_groups.segment25%type
185: ,pgp_segment26 pay_people_groups.segment26%type
186: ,pgp_segment27 pay_people_groups.segment27%type
187: ,pgp_segment28 pay_people_groups.segment28%type
188: ,pgp_segment29 pay_people_groups.segment29%type
189: ,pgp_segment30 pay_people_groups.segment30%type
190: ,people_group_id per_all_assignments_f.people_group_id%type
191: ,scl_segment1 hr_soft_coding_keyflex.segment1%type
192: ,scl_segment2 hr_soft_coding_keyflex.segment2%type

Line 189: ,pgp_segment30 pay_people_groups.segment30%type

185: ,pgp_segment26 pay_people_groups.segment26%type
186: ,pgp_segment27 pay_people_groups.segment27%type
187: ,pgp_segment28 pay_people_groups.segment28%type
188: ,pgp_segment29 pay_people_groups.segment29%type
189: ,pgp_segment30 pay_people_groups.segment30%type
190: ,people_group_id per_all_assignments_f.people_group_id%type
191: ,scl_segment1 hr_soft_coding_keyflex.segment1%type
192: ,scl_segment2 hr_soft_coding_keyflex.segment2%type
193: ,scl_segment3 hr_soft_coding_keyflex.segment3%type