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_ASSIGNMENT_ACTIONS

Line 192: pay_assignment_actions paa

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'
196: and pai.action_information_category = 'GB_SWF_STAFF_DETAILS'

Line 278: pay_assignment_actions paa

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'
282: and pai.action_information_category = 'GB_SWF_CONTRACT_DETAILS'

Line 293: pay_assignment_actions paa

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'
297: and pai.action_information_category = 'GB_SWF_PAYMENT_DETAILS'

Line 304: pay_assignment_actions paa

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'
308: and pai.action_information_category = 'GB_SWF_ADD_PAYMENT_DETAILS'

Line 316: pay_assignment_actions paa

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'
320: and pai.action_information_category = 'GB_SWF_HOURS_DETAILS'

Line 326: pay_assignment_actions paa

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'
330: and pai.action_information_category = 'GB_SWF_ROLE_DETAILS'

Line 442: pay_assignment_actions paa

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'
446: and pai.action_information_category = 'GB_SWF_ABS_DETAILS'

Line 485: pay_assignment_actions paa

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'
489: and pai.action_information_category = 'GB_SWF_QUAL_DETAILS'

Line 523: pay_assignment_actions paa

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'
527: and pai.action_information_category = 'GB_SWF_ROLE_DETAILS'

Line 534: pay_assignment_actions paa

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'
538: and pai.action_information_category = 'GB_SWF_ROLE_DETAILS'

Line 546: pay_assignment_actions paa

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
550: and pai.action_information_category = 'GB_SWF_ROLE_DETAILS'

Line 604: pay_assignment_actions paa

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'
608: and pai.action_information_category = 'GB_SWF_STAFF_DETAILS';

Line 613: pay_assignment_actions paa

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'
617: and pai.action_information_category = 'GB_SWF_STAFF_DETAILS';

Line 622: pay_assignment_actions paa

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'
626: and pai.action_information_category = 'GB_SWF_STAFF_DETAILS'

Line 636: pay_assignment_actions paa

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'
640: and pai.action_information_category = 'GB_SWF_CONTRACT_DETAILS'

Line 647: pay_assignment_actions paa

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'
651: and pai.action_information_category ='GB_SWF_STAFF_DETAILS'