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 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 213: FROM pay_action_interlocks pai, -- run interlock by archive assact

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

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

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

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

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

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

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

Line 794: FROM pay_action_interlocks xpai2,

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

Line 805: FROM pay_action_interlocks vpai,

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

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

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

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

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

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

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

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

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