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.PQP_GB_SWF_EXTRACT dependencies on PAY_ACTION_INFORMATION

Line 55: l_data pay_action_information.action_information1%type;

51: g_edu_psy_fte varchar2(100);
52:
53: PROCEDURE WRITE_LINE(p_tag_type varchar2,p_tag_name varchar2,p_tag_value varchar2) AS
54: l_proc constant varchar2(100):= g_package||'WRITE_LINE';
55: l_data pay_action_information.action_information1%type;
56: BEGIN
57: hr_utility.trace('Entering: '||l_proc);
58:
59: IF p_tag_type = 'O' THEN -- Open Tag

Line 175: PROCEDURE WRITE_STAFF_DETAILS(p_person_id pay_action_information.action_information1%type,

171:
172: hr_utility.trace('Leaving: '||l_proc);
173: END WRITE_HEADER;
174:
175: PROCEDURE WRITE_STAFF_DETAILS(p_person_id pay_action_information.action_information1%type,
176: p_person_category number)
177: AS
178: cursor c_staff_details is
179: select pai.action_information3 teacher_number,

Line 191: from pay_action_information pai,

187: pai.action_information11 disability,
188: max(pai.action_information12)over() QTStatus,
189: max(pai.action_information13)over() HLTAStatus,
190: max(pai.action_information14)over() QTSRoute
191: from pay_action_information pai,
192: pay_assignment_actions paa
193: where paa.payroll_action_id = g_payroll_action_id
194: and paa.assignment_action_id = pai.action_context_id
195: and pai.action_context_type = 'AAP'

Line 261: PROCEDURE WRITE_CONTRACT_DETAILS(p_est_number pay_action_information.action_information11%type,

257:
258: hr_utility.trace('Entering: '||l_proc);
259: END WRITE_STAFF_DETAILS;
260:
261: PROCEDURE WRITE_CONTRACT_DETAILS(p_est_number pay_action_information.action_information11%type,
262: p_person_id pay_action_information.action_information1%type,
263: p_person_category number) AS
264:
265: cursor c_contract_details is

Line 262: p_person_id pay_action_information.action_information1%type,

258: hr_utility.trace('Entering: '||l_proc);
259: END WRITE_STAFF_DETAILS;
260:
261: PROCEDURE WRITE_CONTRACT_DETAILS(p_est_number pay_action_information.action_information11%type,
262: p_person_id pay_action_information.action_information1%type,
263: p_person_category number) AS
264:
265: cursor c_contract_details is
266: select pai.assignment_id assignment_id,

Line 277: from pay_action_information pai,

273: pai.action_information8 destination,
274: pai.action_information9 origin,
275: pai.action_information10 la_school_level,
276: pai.action_information11 est_number
277: from pay_action_information pai,
278: pay_assignment_actions paa
279: where paa.payroll_action_id = g_payroll_action_id
280: and paa.assignment_action_id = pai.action_context_id
281: and pai.action_context_type = 'AAP'

Line 286: cursor c_payment_details(cp_assignment_id pay_action_information.assignment_id%type) is

282: and pai.action_information_category = 'GB_SWF_CONTRACT_DETAILS'
283: and pai.action_information1 = p_person_id
284: and pai.action_information11 = nvl(p_est_number,pai.action_information11);
285:
286: cursor c_payment_details(cp_assignment_id pay_action_information.assignment_id%type) is
287: select pai.action_information1 pay_scale,
288: pai.action_information2 regional_pay_spine,
289: pai.action_information3 spine_point,
290: pai.action_information4 salary_rate,

Line 292: from pay_action_information pai,

288: pai.action_information2 regional_pay_spine,
289: pai.action_information3 spine_point,
290: pai.action_information4 salary_rate,
291: pai.action_information5 safeguarded_salary
292: from pay_action_information pai,
293: pay_assignment_actions paa
294: where paa.payroll_action_id = g_payroll_action_id
295: and paa.assignment_action_id = pai.action_context_id
296: and pai.action_context_type = 'AAP'

Line 300: cursor c_add_payment_details(cp_assignment_id pay_action_information.assignment_id%type) is

296: and pai.action_context_type = 'AAP'
297: and pai.action_information_category = 'GB_SWF_PAYMENT_DETAILS'
298: and pai.assignment_id = cp_assignment_id;
299:
300: cursor c_add_payment_details(cp_assignment_id pay_action_information.assignment_id%type) is
301: select pai.action_information1 cat_of_add_payment,
302: pai.action_information2 add_payment_amt
303: from pay_action_information pai,
304: pay_assignment_actions paa

Line 303: from pay_action_information pai,

299:
300: cursor c_add_payment_details(cp_assignment_id pay_action_information.assignment_id%type) is
301: select pai.action_information1 cat_of_add_payment,
302: pai.action_information2 add_payment_amt
303: from pay_action_information pai,
304: pay_assignment_actions paa
305: where paa.payroll_action_id = g_payroll_action_id
306: and paa.assignment_action_id = pai.action_context_id
307: and pai.action_context_type = 'AAP'

Line 311: cursor c_hours_details(cp_assignment_id pay_action_information.assignment_id%type) is

307: and pai.action_context_type = 'AAP'
308: and pai.action_information_category = 'GB_SWF_ADD_PAYMENT_DETAILS'
309: and pai.assignment_id = cp_assignment_id;
310:
311: cursor c_hours_details(cp_assignment_id pay_action_information.assignment_id%type) is
312: select pai.action_information1 hours_worked_per_week,
313: pai.action_information2 fte_hours_per_week,
314: pai.action_information3 weeks_per_year
315: from pay_action_information pai,

Line 315: from pay_action_information pai,

311: cursor c_hours_details(cp_assignment_id pay_action_information.assignment_id%type) is
312: select pai.action_information1 hours_worked_per_week,
313: pai.action_information2 fte_hours_per_week,
314: pai.action_information3 weeks_per_year
315: from pay_action_information pai,
316: pay_assignment_actions paa
317: where paa.payroll_action_id = g_payroll_action_id
318: and paa.assignment_action_id = pai.action_context_id
319: and pai.action_context_type = 'AAP'

Line 323: cursor c_role_details(cp_assignment_id pay_action_information.assignment_id%type) is

319: and pai.action_context_type = 'AAP'
320: and pai.action_information_category = 'GB_SWF_HOURS_DETAILS'
321: and pai.assignment_id = cp_assignment_id;
322:
323: cursor c_role_details(cp_assignment_id pay_action_information.assignment_id%type) is
324: select pai.action_information1 role_identifier
325: from pay_action_information pai,
326: pay_assignment_actions paa
327: where paa.payroll_action_id = g_payroll_action_id

Line 325: from pay_action_information pai,

321: and pai.assignment_id = cp_assignment_id;
322:
323: cursor c_role_details(cp_assignment_id pay_action_information.assignment_id%type) is
324: select pai.action_information1 role_identifier
325: from pay_action_information pai,
326: pay_assignment_actions paa
327: where paa.payroll_action_id = g_payroll_action_id
328: and paa.assignment_action_id = pai.action_context_id
329: and pai.action_context_type = 'AAP'

Line 432: PROCEDURE WRITE_ABS_DETAILS(p_est_number pay_action_information.action_information6%type,

428:
429: hr_utility.trace('Leaving: '||l_proc);
430: END WRITE_CONTRACT_DETAILS;
431:
432: PROCEDURE WRITE_ABS_DETAILS(p_est_number pay_action_information.action_information6%type,
433: p_person_id pay_action_information.action_information1%type) AS
434:
435: cursor c_abs_details is
436: select pai.action_information2 first_day,

Line 433: p_person_id pay_action_information.action_information1%type) AS

429: hr_utility.trace('Leaving: '||l_proc);
430: END WRITE_CONTRACT_DETAILS;
431:
432: PROCEDURE WRITE_ABS_DETAILS(p_est_number pay_action_information.action_information6%type,
433: p_person_id pay_action_information.action_information1%type) AS
434:
435: cursor c_abs_details is
436: select pai.action_information2 first_day,
437: pai.action_information3 last_day,

Line 441: from pay_action_information pai,

437: pai.action_information3 last_day,
438: pai.action_information4 working_days_lost,
439: pai.action_information5 abs_catagory,
440: pai.action_information6 est_number
441: from pay_action_information pai,
442: pay_assignment_actions paa
443: where paa.payroll_action_id = g_payroll_action_id
444: and paa.assignment_action_id = pai.action_context_id
445: and pai.action_context_type = 'AAP'

Line 469: PROCEDURE WRITE_QUAL_DETAILS(p_est_number pay_action_information.action_information6%type,

465:
466: hr_utility.trace('Leaving: '||l_proc);
467: END WRITE_ABS_DETAILS;
468:
469: PROCEDURE WRITE_QUAL_DETAILS(p_est_number pay_action_information.action_information6%type,
470: p_person_id pay_action_information.action_information1%type) AS
471:
472:
473: cursor c_qual_details is

Line 470: p_person_id pay_action_information.action_information1%type) AS

466: hr_utility.trace('Leaving: '||l_proc);
467: END WRITE_ABS_DETAILS;
468:
469: PROCEDURE WRITE_QUAL_DETAILS(p_est_number pay_action_information.action_information6%type,
470: p_person_id pay_action_information.action_information1%type) AS
471:
472:
473: cursor c_qual_details is
474: select pai.action_information2 qual_code,

Line 484: from pay_action_information pai,

480: pai.action_information3 qual_subject1,
481: pai.action_information4 qual_subject2,
482: -- Bug 12906657
483: pai.action_information6 est_number
484: from pay_action_information pai,
485: pay_assignment_actions paa
486: where paa.payroll_action_id = g_payroll_action_id
487: and paa.assignment_action_id = pai.action_context_id
488: and pai.action_context_type = 'AAP'

Line 522: from pay_action_information pai,

518: PROCEDURE WRITE_LA AS
519:
520: cursor c_edu_psy_ft is
521: select COUNT(*) edu_psy_ft
522: from pay_action_information pai,
523: pay_assignment_actions paa
524: where paa.payroll_action_id = g_payroll_action_id
525: and paa.assignment_action_id = pai.action_context_id
526: and pai.action_context_type = 'AAP'

Line 533: from pay_action_information pai,

529: and pai.action_information2 = 'F';
530:
531: cursor c_edu_psy_pt is
532: select COUNT(*) edu_psy_pt
533: from pay_action_information pai,
534: pay_assignment_actions paa
535: where paa.payroll_action_id = g_payroll_action_id
536: and paa.assignment_action_id = pai.action_context_id
537: and pai.action_context_type = 'AAP'

Line 544: from pay_action_information pai,

540: and pai.action_information2 = 'P';
541:
542: cursor c_edu_psy_fte is
543: select sum(round(nvl(pai2.action_information7,0),1)) edu_psy_fte
544: from pay_action_information pai,
545: pay_action_information pai2,
546: pay_assignment_actions paa
547: where paa.payroll_action_id = g_payroll_action_id
548: and paa.assignment_action_id = pai.action_context_id

Line 545: pay_action_information pai2,

541:
542: cursor c_edu_psy_fte is
543: select sum(round(nvl(pai2.action_information7,0),1)) edu_psy_fte
544: from pay_action_information pai,
545: pay_action_information pai2,
546: pay_assignment_actions paa
547: where paa.payroll_action_id = g_payroll_action_id
548: and paa.assignment_action_id = pai.action_context_id
549: and pai.action_context_id = pai2.action_context_id

Line 603: from pay_action_information pai,

599: where ppa.request_id = p_request_id;
600:
601: cursor c_all_staff is
602: select distinct pai.action_information1 person_id
603: from pay_action_information pai,
604: pay_assignment_actions paa
605: where paa.payroll_action_id = g_payroll_action_id
606: and paa.assignment_action_id = pai.action_context_id
607: and pai.action_context_type = 'AAP'

Line 612: from pay_action_information pai,

608: and pai.action_information_category = 'GB_SWF_STAFF_DETAILS';
609:
610: cursor c_all_eatab is
611: select distinct pai.action_information2 est_number
612: from pay_action_information pai,
613: pay_assignment_actions paa
614: where paa.payroll_action_id = g_payroll_action_id
615: and paa.assignment_action_id = pai.action_context_id
616: and pai.action_context_type = 'AAP'

Line 619: cursor c_estab_staff(cp_est_number pay_action_information.action_information2%type) is

615: and paa.assignment_action_id = pai.action_context_id
616: and pai.action_context_type = 'AAP'
617: and pai.action_information_category = 'GB_SWF_STAFF_DETAILS';
618:
619: cursor c_estab_staff(cp_est_number pay_action_information.action_information2%type) is
620: select distinct pai.action_information1 person_id
621: from pay_action_information pai,
622: pay_assignment_actions paa
623: where paa.payroll_action_id = g_payroll_action_id

Line 621: from pay_action_information pai,

617: and pai.action_information_category = 'GB_SWF_STAFF_DETAILS';
618:
619: cursor c_estab_staff(cp_est_number pay_action_information.action_information2%type) is
620: select distinct pai.action_information1 person_id
621: from pay_action_information pai,
622: pay_assignment_actions paa
623: where paa.payroll_action_id = g_payroll_action_id
624: and paa.assignment_action_id = pai.action_context_id
625: and pai.action_context_type = 'AAP'

Line 633: cursor c_person_category(cp_person_id pay_action_information.action_information1%type) is

629: OR
630: (cp_est_number is not null AND pai.action_information2 = cp_est_number)
631: );
632:
633: cursor c_person_category(cp_person_id pay_action_information.action_information1%type) is
634: select min(pai.action_information14) person_category
635: from pay_action_information pai,
636: pay_assignment_actions paa
637: where paa.payroll_action_id = g_payroll_action_id

Line 635: from pay_action_information pai,

631: );
632:
633: cursor c_person_category(cp_person_id pay_action_information.action_information1%type) is
634: select min(pai.action_information14) person_category
635: from pay_action_information pai,
636: pay_assignment_actions paa
637: where paa.payroll_action_id = g_payroll_action_id
638: and paa.assignment_action_id = pai.action_context_id
639: and pai.action_context_type = 'AAP'

Line 646: from pay_action_information pai,

642:
643: cursor c_estab_staff_count is
644: select pai.action_information2 est_number,
645: count(distinct pai.action_information1) staff_count
646: from pay_action_information pai,
647: pay_assignment_actions paa
648: where paa.payroll_action_id = g_payroll_action_id
649: and paa.assignment_action_id = pai.action_context_id
650: and pai.action_context_type = 'AAP'