DBA Data[Home] [Help]

APPS.PQH_PQHEEO4_XMLP_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

Line 90: PQH_EMPLOYMENT_CATEGORY.FETCH_EMPL_CATEGORIES(P_BUSINESS_GROUP_ID

86: ,-12) + 1) || ''' AND ''' || TO_CHAR(L_REPORT_DATE) || ''' ';
87: L_ROW_COUNT NUMBER := 0;
88: L_FRC VARCHAR2(2000);
89: BEGIN
90: PQH_EMPLOYMENT_CATEGORY.FETCH_EMPL_CATEGORIES(P_BUSINESS_GROUP_ID
91: ,L_FR
92: ,L_FT
93: ,L_PR
94: ,L_PT);

Line 155: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

151: DBMS_SQL.CLOSE_CURSOR(SOURCE_CURSOR);
152: IF (L_FT_EMP_COUNT > P_BPT_FT_EMP_COUNT) THEN
153: P_EEO4_QUERY := 'SELECT job.job_information7 Job_function_code,
154: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,
155: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
156: ''FR'', ''1. FULL-TIME EMPLOYEES'',
157: ''2. OTHER THAN FULL-TIME EMPLOYEES'')) CF_TOTAL_TITLE,
158: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,
159: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

Line 159: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

155: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
156: ''FR'', ''1. FULL-TIME EMPLOYEES'',
157: ''2. OTHER THAN FULL-TIME EMPLOYEES'')) CF_TOTAL_TITLE,
158: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,
159: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
160: ''FR'', ''1. FULL-TIME EMPLOYEES'',
161: ''2. OTHER THAN FULL-TIME EMPLOYEES'') Employment_Category,
162: hl.lookup_code job_category_code,
163: hl.meaning Job_category_name,

Line 165: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

161: ''2. OTHER THAN FULL-TIME EMPLOYEES'') Employment_Category,
162: hl.lookup_code job_category_code,
163: hl.meaning Job_category_name,
164: pqh_salary_range_pkg.get_salary_range(
165: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
166: NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor) Salary_range, ' || SELECT_CLAUSE || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || '
167: AND job.job_information7 IN (' || L_DYNAMIC_WHERE || ')
168: GROUP BY job.job_information7,
169: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

Line 169: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

165: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
166: NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor) Salary_range, ' || SELECT_CLAUSE || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || '
167: AND job.job_information7 IN (' || L_DYNAMIC_WHERE || ')
168: GROUP BY job.job_information7,
169: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
170: ''FR'', ''1. FULL-TIME EMPLOYEES'',
171: ''2. OTHER THAN FULL-TIME EMPLOYEES''),
172: hl.lookup_code ,
173: hl.meaning ,

Line 175: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

171: ''2. OTHER THAN FULL-TIME EMPLOYEES''),
172: hl.lookup_code ,
173: hl.meaning ,
174: pqh_salary_range_pkg.get_salary_range(
175: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
176: NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor)
177: UNION
178: SELECT job.job_information7,
179: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,

Line 194: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

190: hl.meaning
191: UNION
192: SELECT ''XX'',
193: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,
194: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
195: ''FR'', ''1. FULL-TIME EMPLOYEES'',
196: ''2. OTHER THAN FULL-TIME EMPLOYEES'')) CF_TOTAL_TITLE,
197: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,
198: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

Line 198: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

194: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
195: ''FR'', ''1. FULL-TIME EMPLOYEES'',
196: ''2. OTHER THAN FULL-TIME EMPLOYEES'')) CF_TOTAL_TITLE,
197: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,
198: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
199: ''FR'', ''1. FULL-TIME EMPLOYEES'',
200: ''2. OTHER THAN FULL-TIME EMPLOYEES'') ,
201: hl.lookup_code ,
202: hl.meaning ,

Line 204: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

200: ''2. OTHER THAN FULL-TIME EMPLOYEES'') ,
201: hl.lookup_code ,
202: hl.meaning ,
203: pqh_salary_range_pkg.get_salary_range(
204: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
205: NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor), ' || SELECT_CLAUSE || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || '
206: AND job.job_information7 NOT IN (' || L_DYNAMIC_WHERE || ')
207: GROUP BY
208: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

Line 208: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

204: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
205: NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor), ' || SELECT_CLAUSE || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || '
206: AND job.job_information7 NOT IN (' || L_DYNAMIC_WHERE || ')
207: GROUP BY
208: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
209: ''FR'', ''1. FULL-TIME EMPLOYEES'',
210: ''2. OTHER THAN FULL-TIME EMPLOYEES''),
211: hl.lookup_code ,
212: hl.meaning ,

Line 214: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

210: ''2. OTHER THAN FULL-TIME EMPLOYEES''),
211: hl.lookup_code ,
212: hl.meaning ,
213: pqh_salary_range_pkg.get_salary_range(
214: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
215: NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor)
216: UNION
217: SELECT ''XX'',
218: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,

Line 233: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

229: hl.meaning ';
230: ELSE
231: P_EEO4_QUERY := 'SELECT job.job_information7 Job_function_code,
232: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,
233: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
234: ''FR'', ''1. FULL-TIME EMPLOYEES'',
235: ''2. OTHER THAN FULL-TIME EMPLOYEES'')) CF_TOTAL_TITLE,
236: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,
237: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

Line 237: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

233: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
234: ''FR'', ''1. FULL-TIME EMPLOYEES'',
235: ''2. OTHER THAN FULL-TIME EMPLOYEES'')) CF_TOTAL_TITLE,
236: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,
237: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
238: ''FR'', ''1. FULL-TIME EMPLOYEES'',
239: ''2. OTHER THAN FULL-TIME EMPLOYEES'') Employment_Category,
240: hl.lookup_code job_category_code,
241: hl.meaning Job_category_name,

Line 243: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

239: ''2. OTHER THAN FULL-TIME EMPLOYEES'') Employment_Category,
240: hl.lookup_code job_category_code,
241: hl.meaning Job_category_name,
242: pqh_salary_range_pkg.get_salary_range(
243: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
244: NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor) Salary_range, ' || SELECT_CLAUSE || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || '
245: AND job.job_information7 IN (' || L_DYNAMIC_WHERE || ')
246: GROUP BY job.job_information7,
247: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

Line 247: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

243: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
244: NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor) Salary_range, ' || SELECT_CLAUSE || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || '
245: AND job.job_information7 IN (' || L_DYNAMIC_WHERE || ')
246: GROUP BY job.job_information7,
247: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
248: ''FR'', ''1. FULL-TIME EMPLOYEES'',
249: ''2. OTHER THAN FULL-TIME EMPLOYEES''),
250: hl.lookup_code ,
251: hl.meaning ,

Line 253: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

249: ''2. OTHER THAN FULL-TIME EMPLOYEES''),
250: hl.lookup_code ,
251: hl.meaning ,
252: pqh_salary_range_pkg.get_salary_range(
253: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
254: NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor)
255: UNION
256: SELECT job.job_information7,
257: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,

Line 272: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

268: hl.meaning
269: UNION
270: SELECT ''XX'' ,
271: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,
272: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
273: ''FR'', ''1. FULL-TIME EMPLOYEES'',
274: ''2. OTHER THAN FULL-TIME EMPLOYEES'')) CF_TOTAL_TITLE,
275: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,
276: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

Line 276: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

272: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
273: ''FR'', ''1. FULL-TIME EMPLOYEES'',
274: ''2. OTHER THAN FULL-TIME EMPLOYEES'')) CF_TOTAL_TITLE,
275: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,
276: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
277: ''FR'', ''1. FULL-TIME EMPLOYEES'',
278: ''2. OTHER THAN FULL-TIME EMPLOYEES'') ,
279: hl.lookup_code ,
280: hl.meaning ,

Line 282: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

278: ''2. OTHER THAN FULL-TIME EMPLOYEES'') ,
279: hl.lookup_code ,
280: hl.meaning ,
281: pqh_salary_range_pkg.get_salary_range(
282: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
283: NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor) , ' || SELECT_CLAUSE || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || '
284: GROUP BY
285: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
286: ''FR'', ''1. FULL-TIME EMPLOYEES'',

Line 285: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

281: pqh_salary_range_pkg.get_salary_range(
282: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
283: NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor) , ' || SELECT_CLAUSE || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || '
284: GROUP BY
285: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
286: ''FR'', ''1. FULL-TIME EMPLOYEES'',
287: ''2. OTHER THAN FULL-TIME EMPLOYEES''),
288: hl.lookup_code ,
289: hl.meaning ,

Line 291: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),

287: ''2. OTHER THAN FULL-TIME EMPLOYEES''),
288: hl.lookup_code ,
289: hl.meaning ,
290: pqh_salary_range_pkg.get_salary_range(
291: pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),
292: NVL(ppp.proposed_salary_n,0) * ppb.pay_annualization_factor)
293: UNION
294: SELECT ''XX'',
295: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,