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

Line 247: from pay_assignment_actions act,

243:
244: if l_payroll_id is not null then
245: --Bug 3331023-- Rule hint is used only for database version < 10.0
246: sqlstr := 'select '||l_db_version||' distinct pos.person_id
247: from pay_assignment_actions act,
248: per_all_assignments_f asg,
249: per_periods_of_service pos,
250: pay_payroll_actions pa2,
251: pay_payroll_actions pa1,

Line 275: from pay_assignment_actions act,

271: --
272: else
273: --Bug 3331023-- Rule hint is used only for database version < 10.0
274: sqlstr := 'select '||l_db_version||' distinct pos.person_id
275: from pay_assignment_actions act,
276: per_all_assignments_f asg,
277: per_periods_of_service pos,
278: pay_payroll_actions pa2,
279: pay_payroll_actions pa1,

Line 331: pay_assignment_actions paa_mag,

327: from dual
328: where exists
329: (select 1
330: from pay_action_interlocks pai_mag,
331: pay_assignment_actions paa_mag,
332: pay_payroll_actions ppa_mag
333: where pai_mag.locked_action_id = cp_prepayment_action_id
334: and pai_mag.locking_Action_id = paa_mag.assignment_action_id
335: and paa_mag.payroll_action_id = ppa_mag.payroll_action_id

Line 345: pay_assignment_actions paa,

341: and not exists
342: (
343: select 1
344: from pay_action_interlocks pai,
345: pay_assignment_actions paa,
346: pay_payroll_actions ppa
347: where pai.locked_action_id = paa_mag.assignment_action_id
348: and pai.locking_Action_id = paa.assignment_action_id
349: and paa.payroll_action_id = ppa.payroll_action_id

Line 424: from pay_assignment_actions act,

420: ) is
421: select act.assignment_action_id,
422: act.assignment_id,
423: act.tax_unit_id
424: from pay_assignment_actions act,
425: per_all_assignments_f paf1,
426: per_periods_of_service pos,
427: pay_payroll_actions ppa_dar,
428: pay_payroll_actions ppa_mag_pmts,

Line 465: pay_assignment_actions paa4,

461: AND NOT EXISTS
462: ( Select ' '
463: from pay_action_interlocks int2,
464: pay_action_interlocks int4,
465: pay_assignment_actions paa4,
466: pay_payroll_actions ppa_run, --- RUN
467: pay_payroll_actions pact4, --- Reversal
468: pay_assignment_actions paa_run --- RUN
469: where int2.locking_action_id = act.assignment_action_id -- prepayment action

Line 468: pay_assignment_actions paa_run --- RUN

464: pay_action_interlocks int4,
465: pay_assignment_actions paa4,
466: pay_payroll_actions ppa_run, --- RUN
467: pay_payroll_actions pact4, --- Reversal
468: pay_assignment_actions paa_run --- RUN
469: where int2.locking_action_id = act.assignment_action_id -- prepayment action
470: and int2.locked_action_id = paa_run.assignment_action_id
471: and paa_run.payroll_action_id = ppa_run.payroll_action_id
472: and ppa_run.action_type in ('R', 'Q')

Line 497: from pay_assignment_actions act,

493: ) is
494: select act.assignment_action_id,
495: act.assignment_id,
496: act.tax_unit_id
497: from pay_assignment_actions act,
498: per_all_assignments_f paf1,
499: per_all_assignments_f paf2,
500: per_periods_of_service pos,
501: pay_payroll_actions ppa_dar,

Line 543: pay_assignment_actions paa4,

539: and not exists
540: ( select ''
541: from pay_action_interlocks int2,
542: pay_action_interlocks int3,
543: pay_assignment_actions paa4,
544: pay_payroll_actions ppa_run, --- RUN
545: pay_payroll_actions pact4, --- Reversal
546: pay_assignment_actions paa_run, --- RUN
547: pay_assignment_actions paa_pp --- PREPAY

Line 546: pay_assignment_actions paa_run, --- RUN

542: pay_action_interlocks int3,
543: pay_assignment_actions paa4,
544: pay_payroll_actions ppa_run, --- RUN
545: pay_payroll_actions pact4, --- Reversal
546: pay_assignment_actions paa_run, --- RUN
547: pay_assignment_actions paa_pp --- PREPAY
548: where int3.locked_action_id = act.assignment_action_id
549: and int3.locking_action_id = paa_pp.assignment_action_id
550: and int2.locked_action_id = paa_pp.assignment_action_id

Line 547: pay_assignment_actions paa_pp --- PREPAY

543: pay_assignment_actions paa4,
544: pay_payroll_actions ppa_run, --- RUN
545: pay_payroll_actions pact4, --- Reversal
546: pay_assignment_actions paa_run, --- RUN
547: pay_assignment_actions paa_pp --- PREPAY
548: where int3.locked_action_id = act.assignment_action_id
549: and int3.locking_action_id = paa_pp.assignment_action_id
550: and int2.locked_action_id = paa_pp.assignment_action_id
551: and int2.locking_action_id = paa_run.assignment_action_id

Line 586: pay_assignment_actions paa

582:
583: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
584: select assignment_action_id
585: from pay_action_interlocks pai,
586: pay_assignment_actions paa
587: where pai.locking_action_id = cp_pre_pymt_action_id
588: and paa.assignment_Action_id = pai.locked_action_id
589: and paa.run_type_id is null
590: order by action_sequence desc;

Line 648: from pay_assignment_actions act,

644: -- if db_version is < 10 Bug 3331023
645: l_actions := 'select '||l_db_version||' distinct act.assignment_action_id,
646: act.assignment_id,
647: act.tax_unit_id
648: from pay_assignment_actions act,
649: per_all_assignments_f paf1,
650: per_all_assignments_f paf2,
651: per_periods_of_service pos,
652: pay_payroll_actions ppa_dar,

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: pay_assignment_actions paa_pp --- PREPAY

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: pay_assignment_actions paa_pp --- PREPAY
697: where int3.locked_action_id = act.assignment_action_id
698: and int3.locking_action_id = paa_pp.assignment_action_id
699: and int2.locked_action_id = paa_pp.assignment_action_id

Line 696: pay_assignment_actions paa_pp --- PREPAY

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: pay_assignment_actions paa_pp --- PREPAY
697: where int3.locked_action_id = act.assignment_action_id
698: and int3.locking_action_id = paa_pp.assignment_action_id
699: and int2.locked_action_id = paa_pp.assignment_action_id
700: and int2.locking_action_id = paa_run.assignment_action_id

Line 786: select pay_assignment_actions_s.nextval

782: ln_source_action_id <> ln_prev_source_action_id or
783: ln_source_action_id is null) then
784:
785: hr_utility.set_location('procdar',3);
786: select pay_assignment_actions_s.nextval
787: into lockingactid
788: from dual;
789:
790: -- insert the action record.

Line 803: update pay_assignment_Actions

799: if ln_source_action_id is not null then
800:
801: hr_utility.trace('serial number updated if loop ');
802: hr_utility.trace('serial number is '||ln_source_action_id);
803: update pay_assignment_Actions
804: set serial_number = 'P'||ln_source_action_id
805: --set serial_number = ln_source_action_id
806: where assignment_action_id = lockingactid;
807: else

Line 815: update pay_assignment_Actions

811: close c_payroll_run;
812: hr_utility.trace(' ln_master_action_id is'
813: ||to_char(ln_master_action_id));
814:
815: update pay_assignment_Actions
816: set serial_number = 'M'||ln_master_action_id
817: --set serial_number = ln_master_action_id
818: where assignment_action_id = lockingactid;
819: end if;

Line 879: select pay_assignment_actions_s.nextval

875: if (ln_prev_pre_pymt_action_id is null or
876: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
877:
878: hr_utility.set_location('procdar',6);
879: select pay_assignment_actions_s.nextval
880: into ln_deposit_action_id
881: from dual;
882:
883: -- insert the action record.

Line 895: update pay_assignment_Actions

891: hr_utility.trace(' Asg id: '||to_char(ln_assignment_id));
892:
893: /* removed the commented code bug#3438254 */
894:
895: update pay_assignment_Actions
896: set serial_number = 'Z'||ln_direct_dep_act_id
897: where assignment_action_id = ln_deposit_action_id;
898:
899: -- skip till next pre payment action id

Line 930: pay_assignment_actions paa_pyarch,

926: select paa_pyarch.assignment_action_id,
927: paa_pyarch.assignment_id,
928: paa_pyarch.tax_unit_id
929: from pay_payroll_actions ppa_pyarch,
930: pay_assignment_actions paa_pyarch,
931: per_assignments_f paf,
932: pay_action_interlocks pai_pre
933: where ppa_pyarch.report_type = 'PY_ARCHIVER'
934: and ppa_pyarch.report_category = 'RT'

Line 975: pay_assignment_actions paa_rev, --Rev

971: and not exists
972: (Select 1
973: from pay_action_interlocks pai_run, --Pre > Run
974: pay_action_interlocks pai_rev, --Run > Rev
975: pay_assignment_actions paa_rev, --Rev
976: pay_payroll_actions ppa_rev --Rev
977: where pai_run.locking_action_id = pai_pre.locked_action_id
978: and pai_rev.locked_action_id = pai_run.locked_action_id
979: and paa_rev.assignment_action_id = pai_run.locking_action_id

Line 996: pay_assignment_actions paa_mag,

992: from dual
993: where exists
994: (select 1
995: from PAY_EMP_NET_DIST_ACTION_INFO_V net_pay,
996: pay_assignment_actions paa_mag,
997: pay_payroll_actions ppa_mag
998: where net_pay.action_context_id = cp_action_id
999: and net_pay.pre_payment_id = paa_mag.pre_payment_id
1000: and ppa_mag.payroll_action_id = paa_mag.payroll_action_id

Line 1008: pay_assignment_actions paa,

1004: and not exists
1005: (
1006: select 1
1007: from pay_action_interlocks pai,
1008: pay_assignment_actions paa,
1009: pay_payroll_actions ppa
1010: where pai.locked_action_id = paa_mag.assignment_action_id
1011: and pai.locking_Action_id = paa.assignment_action_id
1012: and paa.payroll_action_id = ppa.payroll_action_id

Line 1078: select pay_assignment_actions_s.nextval

1074: hr_utility.trace(' ln_assignment_id is' ||to_char(ln_assignment_id));
1075: hr_utility.trace(' ln_tax_unit_id is' ||to_char(ln_tax_unit_id));
1076:
1077: hr_utility.set_location('pycadar archive_action_creation',3);
1078: select pay_assignment_actions_s.nextval
1079: into ln_deposit_action_id
1080: from dual;
1081:
1082: -- insert the action record.

Line 1090: update pay_assignment_Actions

1086: hr_utility.trace('Inserted into paa, New Asg_act_id:'||to_char(ln_deposit_action_id));
1087: -- insert an interlock to this action.
1088: hr_nonrun_asact.insint(ln_deposit_action_id, ln_dd_action_id);
1089:
1090: update pay_assignment_Actions
1091: set serial_number = ln_dd_action_id
1092: where assignment_action_id = ln_deposit_action_id;
1093:
1094: END IF;

Line 1118: pay_assignment_actions paa,

1114: sqlstr := 'select paa.rowid
1115: from hr_organization_units hou,
1116: per_people_f ppf,
1117: per_assignments_f paf,
1118: pay_assignment_actions paa,
1119: pay_payroll_actions ppa
1120: where ppa.payroll_action_id = :pactid
1121: and paa.payroll_action_id = ppa.payroll_action_id
1122: and paa.assignment_id = paf.assignment_id

Line 1270: FROM pay_assignment_actions paa

1266: ,c_legislation_code VARCHAR2) IS
1267: SELECT /* 'Y' */
1268: distinct paa.assignment_id
1269: ,pai.action_context_id
1270: FROM pay_assignment_actions paa
1271: ,pay_payroll_actions ppa
1272: ,hr_lookups hrl
1273: ,pay_action_information pai
1274: ,per_time_periods ptp

Line 1315: FROM pay_assignment_actions paa

1311: ,c_assignment_set_id NUMBER ) IS
1312: SELECT /* 'Y' */
1313: distinct paa.assignment_id
1314: ,pai.action_context_id
1315: FROM pay_assignment_actions paa
1316: ,pay_payroll_actions ppa
1317: ,hr_lookups hrl
1318: ,hr_assignment_set_amendments hasa
1319: ,pay_action_information pai

Line 1549: pay_assignment_actions paa,

1545: ****************************************************************/
1546: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
1547: select paa.assignment_action_id
1548: from pay_action_interlocks paci,
1549: pay_assignment_actions paa,
1550: pay_payroll_actions ppa
1551: where paci.locking_action_id = cp_assignment_action_id
1552: and paa.assignment_action_id = paci.locked_action_id
1553: and ppa.payroll_action_id = paa.payroll_action_id

Line 1567: pay_assignment_actions paa_pre,

1563: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
1564: select paa_pre.assignment_action_id
1565: from pay_action_interlocks pai_run,
1566: pay_action_interlocks pai_pre,
1567: pay_assignment_actions paa_pre,
1568: pay_payroll_actions ppa_pre
1569: where pai_run.locking_action_id = cp_assignment_action_id
1570: and pai_pre.locked_action_id = pai_run.locked_action_id
1571: and paa_pre.assignment_Action_id = pai_pre.locking_action_id

Line 1620: pay_assignment_actions paa_rev, --Rev

1616: where exists
1617: (Select /*+ ORDERED */ 1
1618: from pay_action_interlocks pai_run, --Pre > Run
1619: pay_action_interlocks pai_rev, --Run > Rev
1620: pay_assignment_actions paa_rev, --Rev
1621: pay_payroll_actions ppa_rev --Rev
1622: where pai_run.locking_action_id = ln_prepay_action_id
1623: and pai_rev.locked_action_id = pai_run.locked_action_id
1624: and paa_rev.assignment_action_id = pai_run.locking_action_id