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_JP_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 134: pay_action_interlocks rpai -- run interlock by archive assact

130: SELECT pes.element_set_name
131: FROM pay_element_sets_vl pes,
132: pay_payroll_actions rppa, -- run pact
133: pay_assignment_actions rpaa, -- run assact
134: pay_action_interlocks rpai -- run interlock by archive assact
135: WHERE rpai.locking_action_id = cp_arch_assignment_action_id
136: AND rpaa.assignment_action_id = rpai.locked_action_id
137: AND rppa.payroll_action_id = rpaa.payroll_action_id
138: -- Element Set is available only when "Run"

Line 214: FROM pay_action_interlocks pai, -- run interlock by archive assact

210: NVL(pettl.reporting_name, pettl.element_name) reporting_name,
211: prrv.input_value_id,
212: prrv.result_value,
213: decode(pbf.scale, 1, 'E', -1, 'D', 'O') payment_type
214: FROM pay_action_interlocks pai, -- run interlock by archive assact
215: pay_assignment_actions rpaa, -- run assact
216: pay_payroll_actions rppa, -- run pact
217: pay_run_results prr,
218: pay_run_result_values prrv,

Line 350: from pay_action_interlocks ppai, -- prepay interlocks by arch assact

346: select /*+ ORDERED */
347: ppaa.assignment_action_id prepay_assignment_action_id,
348: pppa.effective_date prepay_effective_date,
349: ppaa.assignment_id prepay_assignment_id
350: from pay_action_interlocks ppai, -- prepay interlocks by arch assact
351: pay_assignment_actions ppaa, -- prepay assact
352: pay_payroll_actions pppa -- prepay pact
353: where ppai.locking_action_id = cp_arch_assignment_action_id
354: and ppaa.assignment_action_id = ppai.locked_action_id

Line 548: FROM pay_action_interlocks rpai, -- run interlock by archive assact

544: piv.uom,
545: prrv.result_value,
546: piv.lookup_type,
547: piv.value_set_id
548: FROM pay_action_interlocks rpai, -- run interlock by archive assact
549: pay_assignment_actions rpaa, -- run assact
550: pay_payroll_actions rppa, -- run pact
551: pay_run_results prr,
552: hr_organization_information hoi,

Line 767: pay_action_interlocks rpai, -- run interlock by archive assact

763: FROM pay_payroll_actions xppa, -- archive pact
764: pay_payroll_actions pppa, -- prepay pact
765: pay_assignment_actions ppaa, -- prepay assact
766: per_all_assignments_f paaf,
767: pay_action_interlocks rpai, -- run interlock by archive assact
768: pay_assignment_actions rpaa, -- run assact
769: pay_payroll_actions rppa -- run pact
770: WHERE xppa.payroll_action_id = cp_payroll_action_id
771: AND pppa.payroll_id = cp_payroll_id

Line 795: FROM pay_action_interlocks xpai2,

791: AND rppa.action_type IN ('R', 'Q', 'B')
792: AND NOT EXISTS(
793: SELECT /*+ ORDERED */
794: NULL
795: FROM pay_action_interlocks xpai2,
796: pay_assignment_actions xpaa2,
797: pay_payroll_actions xppa2
798: WHERE xpai2.locked_action_id = ppaa.assignment_action_id
799: AND xpaa2.assignment_action_id = xpai2.locking_action_id

Line 806: FROM pay_action_interlocks vpai,

802: AND xppa2.report_type = 'JPPS')
803: AND NOT EXISTS(
804: SELECT /*+ ORDERED */
805: null
806: FROM pay_action_interlocks vpai,
807: pay_assignment_actions vpaa,
808: pay_payroll_actions vppa
809: WHERE vpai.locked_action_id = rpaa.assignment_action_id
810: AND vpaa.assignment_action_id = vpai.locking_action_id

Line 852: hr_utility.trace('inserting into PAY_ACTION_INTERLOCKS (PREPAY)');

848: --
849: -- create an archive to payroll master assignment action interlock and create an archive to
850: -- prepayment assignment action interlock
851: --
852: hr_utility.trace('inserting into PAY_ACTION_INTERLOCKS (PREPAY)');
853: hr_utility.trace('locking_action_id : ' || to_char(l_arch_assignment_action_id));
854: hr_utility.trace('locked_action_id : ' || to_char(l_asg_rec.prepay_assignment_action_id));
855: --
856: hr_nonrun_asact.insint(l_arch_assignment_action_id, l_asg_rec.prepay_assignment_action_id);

Line 859: hr_utility.trace('inserting into PAY_ACTION_INTERLOCKS (RUN)');

855: --
856: hr_nonrun_asact.insint(l_arch_assignment_action_id, l_asg_rec.prepay_assignment_action_id);
857: END IF;
858: --
859: hr_utility.trace('inserting into PAY_ACTION_INTERLOCKS (RUN)');
860: hr_utility.trace('locking_action_id : ' || to_char(l_arch_assignment_action_id));
861: hr_utility.trace('locked_action_id : ' || to_char(l_asg_rec.run_assignment_action_id));
862: --
863: hr_nonrun_asact.insint(l_arch_assignment_action_id, l_asg_rec.run_assignment_action_id);

Line 924: pay_action_interlocks rpai, -- run interlock by archive

920: l_run_effective_date,
921: l_time_period_id,
922: l_organization_id
923: from pay_assignment_actions xpaa, -- archive assact
924: pay_action_interlocks rpai, -- run interlock by archive
925: pay_assignment_actions rpaa, -- run assact
926: pay_payroll_actions rppa, -- run pact
927: per_all_assignments_f asg
928: where xpaa.assignment_action_id = p_assignment_action_id

Line 939: from pay_action_interlocks rpai2, -- run interlock by archive

935: between asg.effective_start_date and asg.effective_end_date
936: and not exists(
937: select /*+ ORDERED */
938: null
939: from pay_action_interlocks rpai2, -- run interlock by archive
940: pay_assignment_actions rpaa2, -- run assact
941: pay_payroll_actions rppa2 -- run pact
942: where rpai2.locking_action_id = xpaa.assignment_action_id
943: and rpaa2.assignment_action_id = rpai2.locked_action_id