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.PYUSDAR_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 167: from pay_assignment_actions act,

163: --
164: if l_payroll_id is not null then
165: --Bug 3331028-- Rule hint is used only for database version < 10.0
166: sqlstr := 'select '||l_db_version||' distinct pos.person_id
167: from pay_assignment_actions act,
168: per_assignments_f asg,
169: per_periods_of_service pos,
170: pay_payroll_actions pa2,
171: pay_payroll_actions pa1

Line 194: from pay_assignment_actions act,

190: else
191: --
192: --Bug 3331028-- Rule hint is used only for database version < 10.0
193: sqlstr := 'select '||l_db_version||' distinct pos.person_id
194: from pay_assignment_actions act,
195: per_assignments_f asg,
196: per_periods_of_service pos,
197: pay_payroll_actions pa2,
198: pay_payroll_actions pa1

Line 238: from pay_assignment_actions act,

234: ) is
235: select act.assignment_action_id,
236: act.assignment_id,
237: act.tax_unit_id
238: from pay_assignment_actions act,
239: per_all_assignments_f paf1,
240: per_all_assignments_f paf2,
241: per_periods_of_service pos,
242: pay_payroll_actions ppa_dar,

Line 286: pay_assignment_actions paa4,

282: (
283: Select ''
284: from pay_action_interlocks int2,
285: pay_action_interlocks int4,
286: pay_assignment_actions paa4,
287: pay_payroll_actions ppa_run, --- RUN
288: pay_payroll_actions pact4, --- Reversal
289: pay_assignment_actions paa_run --- RUN
290: where

Line 289: pay_assignment_actions paa_run --- RUN

285: pay_action_interlocks int4,
286: pay_assignment_actions paa4,
287: pay_payroll_actions ppa_run, --- RUN
288: pay_payroll_actions pact4, --- Reversal
289: pay_assignment_actions paa_run --- RUN
290: where
291: int2.locking_action_id = act.assignment_action_id -- prepayment action
292: and int2.locked_action_id = paa_run.assignment_action_id
293: and paa_run.payroll_action_id = ppa_run.payroll_action_id

Line 317: pay_assignment_actions paa

313:
314: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
315: select assignment_action_id
316: from pay_action_interlocks pai,
317: pay_assignment_actions paa
318: where pai.locking_action_id = cp_pre_pymt_action_id
319: and paa.assignment_Action_id = pai.locked_action_id
320: and paa.run_type_id is null
321: order by action_sequence desc;

Line 375: from pay_assignment_actions act,

371: l_paid_actions := 'select '||l_db_version||' act.assignment_action_id,
372: act.assignment_id,
373: act.tax_unit_id,
374: ppa_mag.effective_date
375: from pay_assignment_actions act,
376: per_all_assignments_f paf1,
377: per_all_assignments_f paf2,
378: per_periods_of_service pos,
379: pay_payroll_actions ppa_dar,

Line 415: pay_assignment_actions paa4,

411: (
412: Select ''''
413: from pay_action_interlocks int2,
414: pay_action_interlocks int3,
415: pay_assignment_actions paa4,
416: pay_payroll_actions ppa_run, --- RUN
417: pay_payroll_actions pact4, --- Reversal
418: pay_assignment_actions paa_run, --- RUN
419: pay_assignment_actions paa_pp --- PREPAY

Line 418: pay_assignment_actions paa_run, --- RUN

414: pay_action_interlocks int3,
415: pay_assignment_actions paa4,
416: pay_payroll_actions ppa_run, --- RUN
417: pay_payroll_actions pact4, --- Reversal
418: pay_assignment_actions paa_run, --- RUN
419: pay_assignment_actions paa_pp --- PREPAY
420: where
421: int3.locked_action_id = act.assignment_action_id
422: and int3.locking_action_id = paa_pp.assignment_action_id

Line 419: pay_assignment_actions paa_pp --- PREPAY

415: pay_assignment_actions paa4,
416: pay_payroll_actions ppa_run, --- RUN
417: pay_payroll_actions pact4, --- Reversal
418: pay_assignment_actions paa_run, --- RUN
419: pay_assignment_actions paa_pp --- PREPAY
420: where
421: int3.locked_action_id = act.assignment_action_id
422: and int3.locking_action_id = paa_pp.assignment_action_id
423: and int2.locked_action_id = paa_pp.assignment_action_id

Line 484: select pay_assignment_actions_s.nextval

480: ln_source_action_id <> ln_prev_source_action_id or
481: ln_source_action_id is null) then
482:
483: hr_utility.set_location('procdar',3);
484: select pay_assignment_actions_s.nextval
485: into ln_deposit_action_id
486: from dual;
487:
488: -- insert the action record.

Line 500: update pay_assignment_Actions

496: hr_utility.trace('Inserted into interlock');
497: if ln_source_action_id is not null then
498: hr_utility.trace('serial number updated if loop ');
499: hr_utility.trace('serial number is '||to_char(ln_source_action_id));
500: update pay_assignment_Actions
501: set serial_number = 'P'||ln_source_action_id
502: --set serial_number = ln_source_action_id
503: where assignment_action_id = ln_deposit_action_id;
504: else

Line 512: update pay_assignment_Actions

508: close c_payroll_run;
509: hr_utility.trace(' ln_master_action_id is'
510: ||to_char(ln_master_action_id));
511:
512: update pay_assignment_Actions
513: set serial_number = 'M'||ln_master_action_id
514: --set serial_number = ln_master_action_id
515: where assignment_action_id = ln_deposit_action_id;
516: end if;

Line 552: select pay_assignment_actions_s.nextval

548: if (ln_prev_pre_pymt_action_id is null or
549: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
550:
551: hr_utility.set_location('procdar',6);
552: select pay_assignment_actions_s.nextval
553: into ln_deposit_action_id
554: from dual;
555:
556: -- insert the action record.

Line 571: update pay_assignment_Actions

567: hr_utility.trace(' NZ ln_master_action_id is'
568: ||to_char(ln_master_action_id));
569: close c_payroll_run;
570:
571: update pay_assignment_Actions
572: set serial_number = 'M'||ln_master_action_id
573: where assignment_action_id = ln_deposit_action_id;
574:
575: -- skip till next pre payment action id

Line 604: pay_assignment_actions paa_run,

600: paa_xfr.tax_unit_id
601: from per_assignments_f paf,
602: pay_payroll_actions ppa_dar,
603: pay_payroll_actions ppa_run,
604: pay_assignment_actions paa_run,
605: pay_action_interlocks pai_pre,
606: pay_action_interlocks pai_run,
607: pay_assignment_actions paa_xfr,
608: pay_payroll_actions ppa_xfr

Line 607: pay_assignment_actions paa_xfr,

603: pay_payroll_actions ppa_run,
604: pay_assignment_actions paa_run,
605: pay_action_interlocks pai_pre,
606: pay_action_interlocks pai_run,
607: pay_assignment_actions paa_xfr,
608: pay_payroll_actions ppa_xfr
609: , pay_payrolls_f pay -- #2264358
610: where ppa_dar.payroll_action_id = pactid
611: and ppa_xfr.report_type = 'XFR_INTERFACE'

Line 636: from pay_assignment_actions paa

632: and pay.payroll_id >= 0 --Bug 3343621
633: and ((pay.multi_assignments_flag = 'Y' and
634: paa_run.assignment_action_id =
635: (select min(paa.assignment_action_id)
636: from pay_assignment_actions paa
637: where paa.assignment_action_id in (
638: select locked_action_id
639: from pay_action_interlocks
640: where locking_action_id = pai_run.locking_action_id)

Line 664: pay_assignment_actions paa_mag,

660: )
661: /* XFR => PRE */
662: and exists ( select 'Y'
663: from pay_action_interlocks pai_mag,
664: pay_assignment_actions paa_mag,
665: pay_payroll_actions ppa_mag
666: where pai_mag.locked_action_id = pai_pre.locked_action_id
667: and pai_mag.locking_Action_id = paa_mag.assignment_action_id
668: and paa_mag.payroll_action_id = ppa_mag.payroll_action_id

Line 692: pay_assignment_actions paa4,

688: (
689: Select ''
690: from pay_action_interlocks int2,
691: pay_action_interlocks int3,
692: pay_assignment_actions paa4,
693: pay_payroll_actions ppa_run, --- RUN
694: pay_payroll_actions pact4, --- Reversal
695: pay_assignment_actions paa_run --- RUN
696: where int2.locked_action_id = pai_pre.locked_action_id

Line 695: pay_assignment_actions paa_run --- RUN

691: pay_action_interlocks int3,
692: pay_assignment_actions paa4,
693: pay_payroll_actions ppa_run, --- RUN
694: pay_payroll_actions pact4, --- Reversal
695: pay_assignment_actions paa_run --- RUN
696: where int2.locked_action_id = pai_pre.locked_action_id
697: and int2.locking_action_id = paa_run.assignment_action_id
698: and paa_run.payroll_action_id = ppa_run.payroll_action_id
699: and ppa_run.action_type in ('R', 'Q')

Line 731: pay_assignment_actions paa_xfr,

727: pay_payroll_actions ppa_run,
728: pay_payroll_actions ppa_pre,
729: pay_action_interlocks pai_pre,
730: pay_action_interlocks pai_run,
731: pay_assignment_actions paa_xfr,
732: pay_assignment_actions paa_pre,
733: pay_assignment_actions paa_run,
734: pay_payroll_actions ppa_xfr
735: , pay_payrolls_f pay -- #2264358

Line 732: pay_assignment_actions paa_pre,

728: pay_payroll_actions ppa_pre,
729: pay_action_interlocks pai_pre,
730: pay_action_interlocks pai_run,
731: pay_assignment_actions paa_xfr,
732: pay_assignment_actions paa_pre,
733: pay_assignment_actions paa_run,
734: pay_payroll_actions ppa_xfr
735: , pay_payrolls_f pay -- #2264358
736: where ppa_dar.payroll_action_id = pactid

Line 733: pay_assignment_actions paa_run,

729: pay_action_interlocks pai_pre,
730: pay_action_interlocks pai_run,
731: pay_assignment_actions paa_xfr,
732: pay_assignment_actions paa_pre,
733: pay_assignment_actions paa_run,
734: pay_payroll_actions ppa_xfr
735: , pay_payrolls_f pay -- #2264358
736: where ppa_dar.payroll_action_id = pactid
737: and pyusdar_pkg.get_parameter('CONSOLIDATION_SET_ID',

Line 767: from pay_assignment_actions paa

763: and pay.payroll_id >= 0 --Bug 3343621
764: and ((pay.multi_assignments_flag = 'Y' and
765: paa_run.assignment_action_id =
766: (select min(paa.assignment_action_id)
767: from pay_assignment_actions paa
768: where paa.assignment_action_id in (select locked_action_id
769: from pay_action_interlocks
770: where locking_action_id = pai_run.locking_action_id)
771: and paa.source_action_id is null

Line 800: pay_assignment_actions paa4,

796: (
797: Select ''
798: from pay_action_interlocks int2,
799: pay_action_interlocks int3,
800: pay_assignment_actions paa4,
801: pay_payroll_actions ppa_run, --- RUN
802: pay_payroll_actions pact4, --- Reversal
803: pay_assignment_actions paa_run --- RUN
804: where int2.locking_action_id = pai_pre.locked_action_id

Line 803: pay_assignment_actions paa_run --- RUN

799: pay_action_interlocks int3,
800: pay_assignment_actions paa4,
801: pay_payroll_actions ppa_run, --- RUN
802: pay_payroll_actions pact4, --- Reversal
803: pay_assignment_actions paa_run --- RUN
804: where int2.locking_action_id = pai_pre.locked_action_id
805: and int2.locked_action_id = paa_run.assignment_action_id
806: and paa_run.payroll_action_id = ppa_run.payroll_action_id
807: and ppa_run.action_type in ('R', 'Q')

Line 875: select pay_assignment_actions_s.nextval

871: hr_utility.trace(' c_paid_actions.ln_nacha_action_id is'
872: ||to_char(ln_nacha_action_id));
873:
874: hr_utility.set_location('procdar archive',3);
875: select pay_assignment_actions_s.nextval
876: into ln_deposit_action_id
877: from dual;
878:
879: -- insert the action record.

Line 887: update pay_assignment_Actions

883: hr_utility.trace('Inserted into paa');
884: -- insert an interlock to this action.
885: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
886:
887: update pay_assignment_Actions
888: set serial_number = ln_nacha_action_id
889: where assignment_action_id = ln_deposit_action_id;
890:
891: END IF;

Line 918: select pay_assignment_actions_s.nextval

914: ass_flag := hr_assignment_set.assignment_in_set(ass_set_id,ln_assignment_id);
915:
916: IF ass_flag = 'Y' THEN
917:
918: select pay_assignment_actions_s.nextval
919: into ln_deposit_action_id
920: from dual;
921:
922: -- insert the action record.

Line 931: update pay_assignment_Actions

927: -- insert an interlock to this action.
928: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
929: hr_utility.trace(' NZ Inserted into paa');
930:
931: update pay_assignment_Actions
932: set serial_number = ln_nacha_action_id
933: where assignment_action_id = ln_deposit_action_id;
934: END IF;
935:

Line 970: pay_assignment_actions paa,

966: sqlstr := 'select '||l_db_version||' paa.rowid
967: from hr_all_organization_units hou,
968: per_all_people_f ppf,
969: per_all_assignments_f paf,
970: pay_assignment_actions paa,
971: pay_payroll_actions ppa
972: where ppa.payroll_action_id = :pactid
973: and paa.payroll_action_id = ppa.payroll_action_id
974: and paa.assignment_id = paf.assignment_id