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 261: from pay_Action_interlocks pai,

257: and paf.effective_end_date >= ppa.start_date
258: and paf.assignment_type = 'E'
259: and not exists
260: (select 'x'
261: from pay_Action_interlocks pai,
262: pay_assignment_actions paa1,
263: pay_payroll_actions ppa1
264: where pai.locked_action_id = paa.assignment_action_id
265: and paa1.assignment_action_id = pai.locking_action_id

Line 273: from pay_Action_interlocks pai,

269: and ppa1.report_type = 'MARK_W2C_PAPER'
270: and ppa1.action_status = 'C')
271: and not exists
272: (select 'x'
273: from pay_Action_interlocks pai,
274: pay_assignment_actions paa1,
275: pay_payroll_actions ppa1
276: where pai.locked_action_id = paa.assignment_action_id
277: and paa1.assignment_action_id = pai.locking_action_id

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

442: and paf.effective_end_date >= ppa.start_date
443: and paf.assignment_type = ''E''
444: and :payroll_action_id is not null
445: and not exists
446: (select ''x'' from pay_Action_interlocks pai,
447: pay_assignment_actions paa1,
448: pay_payroll_actions ppa1
449: where pai.locked_action_id = paa.assignment_action_id
450: and paa1.assignment_action_id = pai.locking_action_id

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

455: and ppa1.action_type = ''X''
456: and ppa1.report_type = ''MARK_W2C_PAPER''
457: and ppa1.action_status = ''C'')
458: and not exists
459: (select ''x'' from pay_Action_interlocks pai,
460: pay_assignment_actions paa1,
461: pay_payroll_actions ppa1
462: where pai.locked_action_id = paa.assignment_action_id
463: and paa1.assignment_action_id = pai.locking_action_id

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

517: and paf.assignment_type = 'E'
518: and paf.person_id between cp_start_person_id
519: and cp_end_person_id
520: and not exists
521: (select 'x' from pay_Action_interlocks pai,
522: pay_assignment_actions paa1,
523: pay_payroll_actions ppa1
524: where pai.locked_action_id = paa.assignment_action_id
525: and paa1.assignment_action_id = pai.locking_action_id

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

529: and ppa1.report_type = 'MARK_W2C_PAPER'
530: and ppa1.report_category = 'RT'
531: and ppa1.action_status = 'C')
532: and not exists
533: (select 'x' from pay_Action_interlocks pai,
534: pay_assignment_actions paa1,
535: pay_payroll_actions ppa1
536: where pai.locked_action_id = paa.assignment_action_id
537: and paa1.assignment_action_id = pai.locking_action_id

Line 548: from pay_Action_interlocks pai,

544: and ppa1.action_status = 'C'
545: )
546: and exists
547: (select 'x'
548: from pay_Action_interlocks pai,
549: pay_assignment_actions paa1,
550: pay_assignment_actions paa2,
551: pay_payroll_actions ppa1,
552: pay_payroll_actions ppa2

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

595: and paf.assignment_type = 'E'
596: and paf.person_id between cp_start_person_id
597: and cp_end_person_id
598: and not exists
599: (select 'x' from pay_Action_interlocks pai,
600: pay_assignment_actions paa1,
601: pay_payroll_actions ppa1
602: where pai.locked_action_id = paa.assignment_action_id
603: and paa1.assignment_action_id = pai.locking_action_id

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

608: and ppa1.report_type = 'MARK_W2C_PAPER'
609: and ppa1.report_category = 'RT'
610: and ppa1.action_status = 'C')
611: and not exists
612: (select 'x' from pay_Action_interlocks pai,
613: pay_assignment_actions paa1,
614: pay_payroll_actions ppa1
615: where pai.locked_action_id = paa.assignment_action_id
616: and paa1.assignment_action_id = pai.locking_action_id

Line 668: from pay_Action_interlocks pai,

664: and paf.effective_end_date >= ppa.start_date
665: and paf.assignment_type = 'E'
666: and not exists
667: (select 'x'
668: from pay_Action_interlocks pai,
669: pay_assignment_actions paa1,
670: pay_payroll_actions ppa1
671: where pai.locked_action_id = paa.assignment_action_id
672: and paa1.assignment_action_id = pai.locking_action_id

Line 680: from pay_Action_interlocks pai,

676: and ppa1.report_type = 'MARK_W2C_PAPER'
677: and ppa1.action_status = 'C')
678: and not exists
679: (select 'x'
680: from pay_Action_interlocks pai,
681: pay_assignment_actions paa1,
682: pay_payroll_actions ppa1
683: where pai.locked_action_id = paa.assignment_action_id
684: and paa1.assignment_action_id = pai.locking_action_id

Line 739: from pay_Action_interlocks pai,

735: and paf.assignment_type = 'E'
736: and paf.person_id = cp_person_id
737: and paa.assignment_Action_id < cp_w2c_paper_action_id
738: and exists ((select 'x'
739: from pay_Action_interlocks pai,
740: pay_assignment_actions paa1,
741: pay_payroll_actions ppa1
742: where pai.locked_action_id = paa.assignment_action_id
743: and paa1.assignment_action_id = pai.locking_action_id

Line 753: from pay_Action_interlocks pai,

749: and ppa1.report_category = 'RT'
750: and ppa1.action_status = 'C')
751: UNION ALL
752: (select 'x'
753: from pay_Action_interlocks pai,
754: pay_assignment_actions paa1,
755: pay_payroll_actions ppa1
756: where pai.locked_action_id = paa.assignment_action_id
757: and paa1.assignment_action_id = pai.locking_action_id

Line 780: pay_action_interlocks pai

776: paa.assignment_action_id locked_action_id,
777: paa.serial_number serial_number
778: from pay_payroll_actions ppa,
779: pay_assignment_actions paa,
780: pay_action_interlocks pai
781: where pai.locking_action_id = cp_locking_action
782: and paa.assignment_action_id = pai.locked_action_id
783: and ppa.payroll_action_id = paa.payroll_action_id;
784: --