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_DEPOSIT_ADVICE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 257: from pay_assignment_actions paa,

253: -- Query is modified for better performance Bug3512116--
254:
255: if ln_payroll_id is not null then
256: sqlstr := 'select '||l_db_version||' distinct paa.assignment_id
257: from pay_assignment_actions paa,
258: pay_payroll_actions ppa
259: where :payroll_action_id is not null
260: and ppa.action_type in (''R'',''Q'')
261: and ppa.consolidation_set_id = ' || ln_consolidation_set_id

Line 270: from pay_assignment_actions paa,

266: order by paa.assignment_id';
267:
268: else
269: sqlstr := 'select '||l_db_version||' distinct paa.assignment_id
270: from pay_assignment_actions paa,
271: pay_payroll_actions ppa
272: where :payroll_action_id is not null
273: and ppa.action_type in (''R'',''Q'')
274: and ppa.consolidation_set_id = ' || ln_consolidation_set_id

Line 309: pay_assignment_actions paa_mag,

305: from dual
306: where exists
307: (select 1
308: from pay_action_interlocks pai_mag,
309: pay_assignment_actions paa_mag,
310: pay_payroll_actions ppa_mag,
311: pay_org_payment_methods_f popm,
312: pay_pre_payments ppp,
313: pay_payment_types ppt

Line 393: pay_assignment_actions paa,

389: ****************************************************************/
390: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
391: select paa.assignment_action_id
392: from pay_action_interlocks paci,
393: pay_assignment_actions paa,
394: pay_payroll_actions ppa
395: where paci.locking_action_id = cp_assignment_action_id
396: and paa.assignment_action_id = paci.locked_action_id
397: and ppa.payroll_action_id = paa.payroll_action_id

Line 411: pay_assignment_actions paa_pre,

407: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
408: select paa_pre.assignment_action_id
409: from pay_action_interlocks pai_run,
410: pay_action_interlocks pai_pre,
411: pay_assignment_actions paa_pre,
412: pay_payroll_actions ppa_pre
413: where pai_run.locking_action_id = cp_assignment_action_id
414: and pai_pre.locked_action_id = pai_run.locked_action_id
415: and paa_pre.assignment_Action_id = pai_pre.locking_action_id

Line 464: pay_assignment_actions paa_rev, --Rev

460: where exists
461: (Select /*+ ORDERED */ 1
462: from pay_action_interlocks pai_run, --Pre > Run
463: pay_action_interlocks pai_rev, --Run > Rev
464: pay_assignment_actions paa_rev, --Rev
465: pay_payroll_actions ppa_rev --Rev
466: where pai_run.locking_action_id = ln_prepay_action_id
467: and pai_rev.locked_action_id = pai_run.locked_action_id
468: and paa_rev.assignment_action_id = pai_run.locking_action_id

Line 512: pay_assignment_actions paa_xfr,

508: paa_xfr.assignment_id,
509: paa_xfr.tax_unit_id
510: from
511: pay_payroll_actions ppa_xfr,
512: pay_assignment_actions paa_xfr,
513: pay_action_interlocks pai_pre
514: where ppa_xfr.report_type = 'XFR_INTERFACE'
515: and ppa_xfr.report_category = 'RT'
516: and ppa_xfr.report_qualifier = 'FED'

Line 546: pay_assignment_actions paa_rev, --Rev

542: and not exists
543: (Select /*+ ORDERED */ 1
544: from pay_action_interlocks pai_run, --Pre > Run
545: pay_action_interlocks pai_rev, --Run > Rev
546: pay_assignment_actions paa_rev, --Rev
547: pay_payroll_actions ppa_rev --Rev
548: where pai_run.locking_action_id = pai_pre.locked_action_id
549: and pai_rev.locked_action_id = pai_run.locked_action_id
550: and paa_rev.assignment_action_id = pai_run.locking_action_id

Line 618: select pay_assignment_actions_s.nextval

614:
615:
616:
617: hr_utility.set_location('procdar archive',3);
618: select pay_assignment_actions_s.nextval
619: into ln_deposit_action_id
620: from dual;
621:
622: -- insert the action record.

Line 630: update pay_assignment_Actions

626: hr_utility.trace('Inserted into paa');
627: -- insert an interlock to this action.
628: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
629:
630: update pay_assignment_Actions
631: set serial_number = ln_nacha_action_id
632: where assignment_action_id = ln_deposit_action_id;
633:
634: END IF;

Line 672: pay_assignment_actions paa,

668: sqlstr := 'select '||l_db_version||' paa.rowid
669: from hr_all_organization_units hou,
670: per_all_people_f ppf,
671: per_all_assignments_f paf,
672: pay_assignment_actions paa,
673: pay_payroll_actions ppa
674: where ppa.payroll_action_id = :pactid
675: and paa.payroll_action_id = ppa.payroll_action_id
676: and paa.assignment_id = paf.assignment_id

Line 724: from pay_assignment_actions act,

720: act.assignment_id,
721: act.tax_unit_id,
722: ppa_mag.effective_date,
723: ppa_mag.action_type
724: from pay_assignment_actions act,
725: pay_payroll_actions ppa_dar,
726: pay_payroll_actions ppa_mag,
727: pay_org_payment_methods_f popm,
728: pay_all_payrolls_f ppf,

Line 777: pay_assignment_actions paa4,

773: and not exists
774: ( select ''
775: from pay_action_interlocks int2,
776: pay_action_interlocks int3,
777: pay_assignment_actions paa4,
778: pay_payroll_actions ppa_run, --- RUN
779: pay_payroll_actions pact4, --- Reversal
780: pay_assignment_actions paa_run, --- RUN
781: pay_assignment_actions paa_pp --- PREPAY

Line 780: pay_assignment_actions paa_run, --- RUN

776: pay_action_interlocks int3,
777: pay_assignment_actions paa4,
778: pay_payroll_actions ppa_run, --- RUN
779: pay_payroll_actions pact4, --- Reversal
780: pay_assignment_actions paa_run, --- RUN
781: pay_assignment_actions paa_pp --- PREPAY
782: where int3.locked_action_id = act.assignment_action_id
783: and int3.locking_action_id = paa_pp.assignment_action_id
784: and int2.locked_action_id = paa_pp.assignment_action_id

Line 781: pay_assignment_actions paa_pp --- PREPAY

777: pay_assignment_actions paa4,
778: pay_payroll_actions ppa_run, --- RUN
779: pay_payroll_actions pact4, --- Reversal
780: pay_assignment_actions paa_run, --- RUN
781: pay_assignment_actions paa_pp --- PREPAY
782: where int3.locked_action_id = act.assignment_action_id
783: and int3.locking_action_id = paa_pp.assignment_action_id
784: and int2.locked_action_id = paa_pp.assignment_action_id
785: and int2.locking_action_id = paa_run.assignment_action_id

Line 810: pay_assignment_actions paa

806:
807: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
808: select assignment_action_id
809: from pay_action_interlocks pai,
810: pay_assignment_actions paa
811: where pai.locking_action_id = cp_pre_pymt_action_id
812: and paa.assignment_Action_id = pai.locked_action_id
813: and paa.run_type_id is null
814: order by action_sequence desc;

Line 888: from pay_assignment_actions act,

884: act.assignment_id,
885: act.tax_unit_id,
886: ppa_mag.effective_date,
887: ppa_mag.action_type
888: from pay_assignment_actions act,
889: pay_payroll_actions ppa_dar,
890: pay_payroll_actions ppa_mag,
891: per_all_assignments_f paf2,
892: pay_org_payment_methods_f popm, --Bug 3009643

Line 936: pay_assignment_actions paa4,

932: (
933: Select ''''
934: from pay_action_interlocks int2,
935: pay_action_interlocks int3,
936: pay_assignment_actions paa4,
937: pay_payroll_actions ppa_run, --- RUN
938: pay_payroll_actions pact4, --- Reversal
939: pay_assignment_actions paa_run, --- RUN
940: pay_assignment_actions paa_pp --- PREPAY

Line 939: pay_assignment_actions paa_run, --- RUN

935: pay_action_interlocks int3,
936: pay_assignment_actions paa4,
937: pay_payroll_actions ppa_run, --- RUN
938: pay_payroll_actions pact4, --- Reversal
939: pay_assignment_actions paa_run, --- RUN
940: pay_assignment_actions paa_pp --- PREPAY
941: where
942: int3.locked_action_id = act.assignment_action_id
943: and int3.locking_action_id = paa_pp.assignment_action_id

Line 940: pay_assignment_actions paa_pp --- PREPAY

936: pay_assignment_actions paa4,
937: pay_payroll_actions ppa_run, --- RUN
938: pay_payroll_actions pact4, --- Reversal
939: pay_assignment_actions paa_run, --- RUN
940: pay_assignment_actions paa_pp --- PREPAY
941: where
942: int3.locked_action_id = act.assignment_action_id
943: and int3.locking_action_id = paa_pp.assignment_action_id
944: and int2.locked_action_id = paa_pp.assignment_action_id

Line 1025: select pay_assignment_actions_s.nextval

1021: ln_source_action_id <> ln_prev_source_action_id or
1022: ln_source_action_id is null) then
1023:
1024: hr_utility.set_location('procdar',3);
1025: select pay_assignment_actions_s.nextval
1026: into ln_deposit_action_id
1027: from dual;
1028:
1029: -- insert the action record.

Line 1041: update pay_assignment_Actions

1037: hr_utility.trace('Inserted into interlock');
1038: if ln_source_action_id is not null then
1039: hr_utility.trace('serial number updated if loop ');
1040: hr_utility.trace('serial number is '||to_char(ln_source_action_id));
1041: update pay_assignment_Actions
1042: set serial_number = 'P'||ln_source_action_id
1043: where assignment_action_id = ln_deposit_action_id;
1044: else
1045: hr_utility.trace('serial number else ');

Line 1052: update pay_assignment_Actions

1048: close c_payroll_run;
1049: hr_utility.trace(' ln_master_action_id is'
1050: ||to_char(ln_master_action_id));
1051:
1052: update pay_assignment_Actions
1053: set serial_number = 'M'||ln_master_action_id
1054: where assignment_action_id = ln_deposit_action_id;
1055: end if;
1056: -- skip till next source action id

Line 1068: select pay_assignment_actions_s.nextval

1064: hr_utility.trace('Zero Pay Assignment');
1065: if (ln_prev_pre_pymt_action_id is null or
1066: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
1067: hr_utility.set_location('procdar',6);
1068: select pay_assignment_actions_s.nextval
1069: into ln_deposit_action_id
1070: from dual;
1071:
1072: -- insert the action record.

Line 1086: update pay_assignment_Actions

1082: open c_payroll_run (ln_nacha_action_id);
1083: fetch c_payroll_run into ln_master_action_id;
1084: close c_payroll_run;
1085:
1086: update pay_assignment_Actions
1087: set serial_number = 'M'||ln_master_action_id
1088: where assignment_action_id = ln_deposit_action_id;
1089:
1090: hr_utility.trace(' NZ ln_master_action_id is'

Line 1162: FROM pay_assignment_actions paa

1158: ,c_legislation_code VARCHAR2) IS
1159: SELECT /* 'Y' */
1160: distinct paa.assignment_id
1161: ,pai.action_context_id
1162: FROM pay_assignment_actions paa
1163: ,pay_payroll_actions ppa
1164: ,hr_lookups hrl
1165: ,pay_action_information pai
1166: ,per_time_periods ptp

Line 1207: FROM pay_assignment_actions paa

1203: ,c_assignment_set_id NUMBER ) IS
1204: SELECT /* 'Y' */
1205: distinct paa.assignment_id
1206: ,pai.action_context_id
1207: FROM pay_assignment_actions paa
1208: ,pay_payroll_actions ppa
1209: ,hr_lookups hrl
1210: ,hr_assignment_set_amendments hasa
1211: ,pay_action_information pai

Line 1479: from pay_assignment_actions paa,

1475: if ln_payroll_id is not null then
1476: if ln_assignment_set_id is not null then
1477:
1478: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1479: from pay_assignment_actions paa,
1480: pay_payroll_actions ppa,
1481: per_assignments_f paf,
1482: hr_assignment_set_amendments hasa
1483: where :payroll_action_id is not null

Line 1497: from pay_assignment_actions paa,

1493: || ' and hasa.include_or_exclude = ''I'''
1494: || ' order by paf.person_id';
1495: else
1496: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1497: from pay_assignment_actions paa,
1498: pay_payroll_actions ppa,
1499: per_assignments_f paf
1500: where :payroll_action_id is not null
1501: and ppa.action_type in (''R'',''Q'')

Line 1514: from pay_assignment_actions paa,

1510:
1511: else
1512: if ln_assignment_set_id is not null then
1513: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1514: from pay_assignment_actions paa,
1515: pay_payroll_actions ppa,
1516: per_assignments_f paf,
1517: hr_assignment_set_amendments hasa
1518: where :payroll_action_id is not null

Line 1532: from pay_assignment_actions paa,

1528: || ' order by paf.person_id';
1529:
1530: else
1531: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1532: from pay_assignment_actions paa,
1533: pay_payroll_actions ppa,
1534: per_assignments_f paf
1535: where :payroll_action_id is not null
1536: and ppa.action_type in (''R'',''Q'')