eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_PQHEEO4_XMLP_PKG dependencies on PQH_PQHEEO4_XMLP_PKG

Line 1: PACKAGE BODY PQH_PQHEEO4_XMLP_PKG AS

1: PACKAGE BODY PQH_PQHEEO4_XMLP_PKG AS
2: /* $Header: PQHEEO4B.pls 120.1 2007/12/07 06:47:50 vjaganat noship $ */
3: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4: L_QUERY_TEXT VARCHAR2(2000);
5: BEGIN

Line 154: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,

150: END LOOP;
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,

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 158: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,

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 || '),
160: ''FR'', ''1. FULL-TIME EMPLOYEES'',
161: ''2. OTHER THAN FULL-TIME EMPLOYEES'') Employment_Category,
162: hl.lookup_code job_category_code,

Line 179: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,

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,
180: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,
181: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,
182: ''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'',
183: hl.lookup_code job_category_code,

Line 180: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,

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,
180: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,
181: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,
182: ''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'',
183: hl.lookup_code job_category_code,
184: hl.meaning Job_category_name,

Line 181: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,

177: UNION
178: SELECT job.job_information7,
179: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,
180: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,
181: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,
182: ''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'',
183: hl.lookup_code job_category_code,
184: hl.meaning Job_category_name,
185: '' '', ' || SELECT_CLAUSE || FROM_WHERE_CLAUSE || L_NH_EFFECTIVE_DATES || '

Line 193: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,

189: hl.lookup_code,
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,

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 197: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,

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 || '),
199: ''FR'', ''1. FULL-TIME EMPLOYEES'',
200: ''2. OTHER THAN FULL-TIME EMPLOYEES'') ,
201: hl.lookup_code ,

Line 218: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,

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,
219: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,
220: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,
221: ''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'',
222: hl.lookup_code job_category_code,

Line 219: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,

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,
219: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,
220: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,
221: ''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'',
222: hl.lookup_code job_category_code,
223: hl.meaning Job_category_name,

Line 220: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,

216: UNION
217: SELECT ''XX'',
218: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,
219: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,
220: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,
221: ''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'',
222: hl.lookup_code job_category_code,
223: hl.meaning Job_category_name,
224: '' '', ' || SELECT_CLAUSE || FROM_WHERE_CLAUSE || L_NH_EFFECTIVE_DATES || '

Line 232: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,

228: hl.lookup_code,
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,

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 236: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,

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 || '),
238: ''FR'', ''1. FULL-TIME EMPLOYEES'',
239: ''2. OTHER THAN FULL-TIME EMPLOYEES'') Employment_Category,
240: hl.lookup_code job_category_code,

Line 257: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,

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,
258: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,
259: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,
260: ''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'',
261: hl.lookup_code job_category_code,

Line 258: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,

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,
258: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,
259: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,
260: ''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'',
261: hl.lookup_code job_category_code,
262: hl.meaning Job_category_name,

Line 259: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,

255: UNION
256: SELECT job.job_information7,
257: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,
258: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,
259: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(job.job_information7) CF_set_function_desc,
260: ''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'',
261: hl.lookup_code job_category_code,
262: hl.meaning Job_category_name,
263: '' '', ' || SELECT_CLAUSE || FROM_WHERE_CLAUSE || L_NH_EFFECTIVE_DATES || '

Line 271: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,

267: hl.lookup_code,
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,

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 275: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,

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 || '),
277: ''FR'', ''1. FULL-TIME EMPLOYEES'',
278: ''2. OTHER THAN FULL-TIME EMPLOYEES'') ,
279: hl.lookup_code ,

Line 295: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,

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,
296: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,
297: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,
298: ''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'',
299: hl.lookup_code job_category_code,

Line 296: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,

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,
296: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,
297: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,
298: ''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'',
299: hl.lookup_code job_category_code,
300: hl.meaning Job_category_name,

Line 297: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,

293: UNION
294: SELECT ''XX'',
295: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,
296: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'') CF_TOTAL_TITLE,
297: PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(''XX'') CF_set_function_desc,
298: ''3. NEW HIRE DURING FISCAL YEAR - PERMANENT FULL TIME ONLY'',
299: hl.lookup_code job_category_code,
300: hl.meaning Job_category_name,
301: '' '', ' || SELECT_CLAUSE || FROM_WHERE_CLAUSE || L_NH_EFFECTIVE_DATES || '

Line 385: END PQH_PQHEEO4_XMLP_PKG;

381: BEGIN
382: RETURN C_END_OF_TIME;
383: END C_END_OF_TIME_P;
384:
385: END PQH_PQHEEO4_XMLP_PKG;