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.PAY_US_W2C_REPORTING_UTILS dependencies on PAY_ACTION_INTERLOCKS

Line 268: from pay_Action_interlocks pai,

264: and paf.effective_end_date >= ppa.start_date
265: and paf.assignment_type = 'E'
266: and not exists
267: (select 'x'
268: from pay_Action_interlocks pai,
269: pay_assignment_actions paa1,
270: pay_payroll_actions ppa1
271: where pai.locked_action_id = paa.assignment_action_id
272: and paa1.assignment_action_id = pai.locking_action_id

Line 280: from pay_Action_interlocks pai,

276: and ppa1.report_type = 'MARK_W2C_PAPER'
277: and ppa1.action_status = 'C')
278: and not exists
279: (select 'x'
280: from pay_Action_interlocks pai,
281: pay_assignment_actions paa1,
282: pay_payroll_actions ppa1
283: where pai.locked_action_id = paa.assignment_action_id
284: and paa1.assignment_action_id = pai.locking_action_id

Line 453: (select ''x'' from pay_Action_interlocks pai,

449: and paf.effective_end_date >= ppa.start_date
450: and paf.assignment_type = ''E''
451: and :payroll_action_id is not null
452: and not exists
453: (select ''x'' from pay_Action_interlocks pai,
454: pay_assignment_actions paa1,
455: pay_payroll_actions ppa1
456: where pai.locked_action_id = paa.assignment_action_id
457: and paa1.assignment_action_id = pai.locking_action_id

Line 466: (select ''x'' from pay_Action_interlocks pai,

462: and ppa1.action_type = ''X''
463: and ppa1.report_type = ''MARK_W2C_PAPER''
464: and ppa1.action_status = ''C'')
465: and not exists
466: (select ''x'' from pay_Action_interlocks pai,
467: pay_assignment_actions paa1,
468: pay_payroll_actions ppa1
469: where pai.locked_action_id = paa.assignment_action_id
470: and paa1.assignment_action_id = pai.locking_action_id

Line 529: (select 'x' from pay_Action_interlocks pai,

525: and paf.assignment_type = 'E'
526: and paf.person_id between cp_start_person_id
527: and cp_end_person_id
528: and not exists
529: (select 'x' from pay_Action_interlocks pai,
530: pay_assignment_actions paa1,
531: pay_payroll_actions ppa1
532: where pai.locked_action_id = paa.assignment_action_id
533: and paa1.assignment_action_id = pai.locking_action_id

Line 541: (select 'x' from pay_Action_interlocks pai,

537: and ppa1.report_type = 'MARK_W2C_PAPER'
538: and ppa1.report_category = 'RT'
539: and ppa1.action_status = 'C')
540: and not exists
541: (select 'x' from pay_Action_interlocks pai,
542: pay_assignment_actions paa1,
543: pay_payroll_actions ppa1
544: where pai.locked_action_id = paa.assignment_action_id
545: and paa1.assignment_action_id = pai.locking_action_id

Line 556: from pay_Action_interlocks pai,

552: and ppa1.action_status = 'C'
553: )
554: and exists
555: (select 'x'
556: from pay_Action_interlocks pai,
557: pay_assignment_actions paa1,
558: pay_assignment_actions paa2,
559: pay_payroll_actions ppa1,
560: pay_payroll_actions ppa2

Line 607: (select 'x' from pay_Action_interlocks pai,

603: and paf.assignment_type = 'E'
604: and paf.person_id between cp_start_person_id
605: and cp_end_person_id
606: and not exists
607: (select 'x' from pay_Action_interlocks pai,
608: pay_assignment_actions paa1,
609: pay_payroll_actions ppa1
610: where pai.locked_action_id = paa.assignment_action_id
611: and paa1.assignment_action_id = pai.locking_action_id

Line 620: (select 'x' from pay_Action_interlocks pai,

616: and ppa1.report_type = 'MARK_W2C_PAPER'
617: and ppa1.report_category = 'RT'
618: and ppa1.action_status = 'C')
619: and not exists
620: (select 'x' from pay_Action_interlocks pai,
621: pay_assignment_actions paa1,
622: pay_payroll_actions ppa1
623: where pai.locked_action_id = paa.assignment_action_id
624: and paa1.assignment_action_id = pai.locking_action_id

Line 679: from pay_Action_interlocks pai,

675: and paf.effective_end_date >= ppa.start_date
676: and paf.assignment_type = 'E'
677: and not exists
678: (select 'x'
679: from pay_Action_interlocks pai,
680: pay_assignment_actions paa1,
681: pay_payroll_actions ppa1
682: where pai.locked_action_id = paa.assignment_action_id
683: and paa1.assignment_action_id = pai.locking_action_id

Line 691: from pay_Action_interlocks pai,

687: and ppa1.report_type = 'MARK_W2C_PAPER'
688: and ppa1.action_status = 'C')
689: and not exists
690: (select 'x'
691: from pay_Action_interlocks pai,
692: pay_assignment_actions paa1,
693: pay_payroll_actions ppa1
694: where pai.locked_action_id = paa.assignment_action_id
695: and paa1.assignment_action_id = pai.locking_action_id

Line 750: from pay_Action_interlocks pai,

746: and paf.assignment_type = 'E'
747: and paf.person_id = cp_person_id
748: and paa.assignment_Action_id < cp_w2c_paper_action_id
749: and exists ((select 'x'
750: from pay_Action_interlocks pai,
751: pay_assignment_actions paa1,
752: pay_payroll_actions ppa1
753: where pai.locked_action_id = paa.assignment_action_id
754: and paa1.assignment_action_id = pai.locking_action_id

Line 764: from pay_Action_interlocks pai,

760: and ppa1.report_category = 'RT'
761: and ppa1.action_status = 'C')
762: UNION ALL
763: (select 'x'
764: from pay_Action_interlocks pai,
765: pay_assignment_actions paa1,
766: pay_payroll_actions ppa1
767: where pai.locked_action_id = paa.assignment_action_id
768: and paa1.assignment_action_id = pai.locking_action_id

Line 791: pay_action_interlocks pai

787: paa.assignment_action_id locked_action_id,
788: paa.serial_number serial_number
789: from pay_payroll_actions ppa,
790: pay_assignment_actions paa,
791: pay_action_interlocks pai
792: where pai.locking_action_id = cp_locking_action
793: and paa.assignment_action_id = pai.locked_action_id
794: and ppa.payroll_action_id = paa.payroll_action_id;
795: --