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

Line 139: FROM PAY_ASSIGNMENT_ACTIONS paa_arch,

135: -- hr_us_w2_rep.initialize_assignment_set(ln_assign_set);
136:
137: sqlstr :=
138: 'SELECT distinct to_number(paa_arch.serial_number)
139: FROM PAY_ASSIGNMENT_ACTIONS paa_arch,
140: PAY_PAYROLL_ACTIONS ppa_arch
141: WHERE :pactid is not null
142: AND ppa_arch.report_type = ''YREND''
143: AND to_char(ppa_arch.effective_date,''YYYY'')= '''||ln_year||'''

Line 188: l_gre_id pay_assignment_actions.tax_unit_id%type;

184:
185: l_procedure_name VARCHAR2(100);
186: l_session_date date;
187: l_year number ;
188: l_gre_id pay_assignment_actions.tax_unit_id%type;
189: l_org_id per_assignments_f.organization_id%type;
190: l_loc_id per_assignments_f.location_id%type;
191: l_per_id per_assignments_f.person_id%type;
192: l_ssn per_people_f.national_identifier%type;

Line 251: pay_assignment_actions paa_arch

247: paa_arch.assignment_id,
248: paa_arch.tax_unit_id,
249: paf.effective_end_date
250: FROM per_assignments_f paf,
251: pay_assignment_actions paa_arch
252: WHERE paa_arch.payroll_action_id = l_eoy_payroll_action_id
253: AND paa_arch.action_status = 'C'
254: AND paf.PERSON_ID = l_per_id
255: AND paa_arch.assignment_id = paf.assignment_id

Line 361: pay_assignment_actions paa_arch,

357: paa_arch.assignment_id,
358: paa_arch.tax_unit_id,
359: paf.effective_end_date
360: FROM per_assignments_f paf,
361: pay_assignment_actions paa_arch,
362: pay_population_ranges ppr
363: WHERE paa_arch.action_status = ''C''
364: AND paa_arch.payroll_action_id +0= ' || l_eoy_payroll_action_id || '
365: AND paa_arch.assignment_id = paf.assignment_id

Line 386: pay_assignment_actions paa_arch

382: paa_arch.assignment_id,
383: paa_arch.tax_unit_id,
384: paf.effective_end_date
385: FROM per_assignments_f paf,
386: pay_assignment_actions paa_arch
387: WHERE paa_arch.action_status = ''C''
388: AND paa_arch.payroll_action_id +0= ' || l_eoy_payroll_action_id || '
389: AND paa_arch.assignment_id = paf.assignment_id
390: AND paf.effective_start_date =

Line 434: select pay_assignment_actions_s.nextval

430: -- for each assignment/pre-payment/reversal).
431: hr_utility.set_location(l_procedure_name, 25);
432: hr_utility.trace('Before inserting the action record');
433:
434: select pay_assignment_actions_s.nextval
435: into lockingactid
436: from dual;
437:
438: -- insert the action record.

Line 441: -- Update serial_numbrt of Pay_assignment_actions with the

437:
438: -- insert the action record.
439: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
440:
441: -- Update serial_numbrt of Pay_assignment_actions with the
442: -- assignment_action_id .
443: update pay_assignment_actions
444: set serial_number = lockedactid
445: where assignment_action_id = lockingactid;

Line 443: update pay_assignment_actions

439: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
440:
441: -- Update serial_numbrt of Pay_assignment_actions with the
442: -- assignment_action_id .
443: update pay_assignment_actions
444: set serial_number = lockedactid
445: where assignment_action_id = lockingactid;
446: end if;
447: end loop;

Line 465: pay_assignment_actions paa_arch,

461: paa_arch.tax_unit_id,
462: paf.effective_end_date
463: FROM per_periods_of_service pps,
464: per_assignments_f paf,
465: pay_assignment_actions paa_arch,
466: pay_population_ranges ppr
467: /* disabling the index for performance reason */
468: WHERE paa_arch.payroll_action_id + 0 = ' || l_eoy_payroll_action_id || '
469: AND paa_arch.action_status = ''C''

Line 495: pay_assignment_actions paa_arch

491: paa_arch.tax_unit_id,
492: paf.effective_end_date
493: FROM per_periods_of_service pps,
494: per_assignments_f paf,
495: pay_assignment_actions paa_arch
496: /* disabling the index for performance reason */
497: WHERE paa_arch.payroll_action_id + 0 = ' || l_eoy_payroll_action_id || '
498: AND paa_arch.action_status = ''C''
499: AND paa_arch.assignment_id = paf.assignment_id

Line 545: select pay_assignment_actions_s.nextval

541:
542: hr_utility.set_location(l_procedure_name, 45);
543: hr_utility.trace('Before inserting the action record');
544:
545: select pay_assignment_actions_s.nextval
546: into lockingactid
547: from dual;
548:
549: -- insert the action record.

Line 552: -- Update serial_numbrt of Pay_assignment_actions with the

548:
549: -- insert the action record.
550: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
551:
552: -- Update serial_numbrt of Pay_assignment_actions with the
553: -- assignment_action_id .
554: update pay_assignment_actions
555: set serial_number = lockedactid
556: where assignment_action_id = lockingactid;

Line 554: update pay_assignment_actions

550: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
551:
552: -- Update serial_numbrt of Pay_assignment_actions with the
553: -- assignment_action_id .
554: update pay_assignment_actions
555: set serial_number = lockedactid
556: where assignment_action_id = lockingactid;
557: end if;
558: end loop;

Line 578: pay_assignment_actions paa_arch,

574: paa_arch.tax_unit_id,
575: paf.effective_end_date
576: FROM per_periods_of_service pps,
577: per_assignments_f paf,
578: pay_assignment_actions paa_arch,
579: pay_population_ranges ppr
580: /* disabling the index for performance reason */
581: WHERE paa_arch.payroll_action_id +0 = ' || l_eoy_payroll_action_id || '
582: AND paa_arch.action_status = ''C''

Line 608: pay_assignment_actions paa_arch

604: paa_arch.tax_unit_id,
605: paf.effective_end_date
606: FROM per_periods_of_service pps,
607: per_assignments_f paf,
608: pay_assignment_actions paa_arch
609: /* disabling the index for performance reason */
610: WHERE paa_arch.payroll_action_id +0 = ' || l_eoy_payroll_action_id || '
611: AND paa_arch.action_status = ''C''
612: AND nvl(pps.final_process_date,''' || l_session_date || ''')

Line 659: select pay_assignment_actions_s.nextval

655:
656: hr_utility.set_location(l_procedure_name, 90);
657: hr_utility.trace('Before inserting the action record');
658:
659: select pay_assignment_actions_s.nextval
660: into lockingactid
661: from dual;
662:
663: -- insert the action record.

Line 666: -- Update serial_numbrt of Pay_assignment_actions with the

662:
663: -- insert the action record.
664: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
665:
666: -- Update serial_numbrt of Pay_assignment_actions with the
667: -- assignment_action_id .
668: update pay_assignment_actions
669: set serial_number = lockedactid
670: where assignment_action_id = lockingactid;

Line 668: update pay_assignment_actions

664: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
665:
666: -- Update serial_numbrt of Pay_assignment_actions with the
667: -- assignment_action_id .
668: update pay_assignment_actions
669: set serial_number = lockedactid
670: where assignment_action_id = lockingactid;
671: end if;
672: end loop;

Line 720: select pay_assignment_actions_s.nextval

716:
717: hr_utility.set_location(l_procedure_name, 110);
718: hr_utility.trace('Before inserting the action record');
719:
720: select pay_assignment_actions_s.nextval
721: into lockingactid
722: from dual;
723:
724: -- insert the action record.

Line 727: -- Update serial_numbrt of Pay_assignment_actions with the

723:
724: -- insert the action record.
725: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
726:
727: -- Update serial_numbrt of Pay_assignment_actions with the
728: -- assignment_action_id .
729: update pay_assignment_actions
730: set serial_number = lockedactid
731: where assignment_action_id = lockingactid;

Line 729: update pay_assignment_actions

725: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
726:
727: -- Update serial_numbrt of Pay_assignment_actions with the
728: -- assignment_action_id .
729: update pay_assignment_actions
730: set serial_number = lockedactid
731: where assignment_action_id = lockingactid;
732: end if;
733: end loop;

Line 761: pay_assignment_actions paa_arch,

757: paa_arch.assignment_id,
758: paa_arch.tax_unit_id,
759: paf.effective_end_date
760: FROM per_assignments_f paf,
761: pay_assignment_actions paa_arch,
762: pay_population_ranges ppr
763: WHERE paa_arch.payroll_action_id +0 = ' || l_eoy_payroll_action_id || '
764: AND paa_arch.action_status = ''C''
765: AND paa_arch.assignment_id = paf.assignment_id

Line 784: pay_assignment_actions paa_arch

780: paa_arch.assignment_id,
781: paa_arch.tax_unit_id,
782: paf.effective_end_date
783: FROM per_assignments_f paf,
784: pay_assignment_actions paa_arch
785: WHERE paa_arch.payroll_action_id +0 = ' || l_eoy_payroll_action_id || '
786: AND paa_arch.action_status = ''C''
787: AND paa_arch.assignment_id = paf.assignment_id
788: AND paf.effective_start_date =

Line 858: select pay_assignment_actions_s.nextval

854:
855: hr_utility.set_location(l_procedure_name, 220);
856: hr_utility.trace('Before inserting the action record');
857:
858: select pay_assignment_actions_s.nextval
859: into lockingactid
860: from dual;
861:
862: -- insert the action record.

Line 865: -- Update serial_numbrt of Pay_assignment_actions with the

861:
862: -- insert the action record.
863: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
864:
865: -- Update serial_numbrt of Pay_assignment_actions with the
866: -- assignment_action_id .
867: update pay_assignment_actions
868: set serial_number = lockedactid
869: where assignment_action_id = lockingactid;

Line 867: update pay_assignment_actions

863: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
864:
865: -- Update serial_numbrt of Pay_assignment_actions with the
866: -- assignment_action_id .
867: update pay_assignment_actions
868: set serial_number = lockedactid
869: where assignment_action_id = lockingactid;
870: end if;
871: end loop;

Line 889: pay_assignment_actions paa_arch,

885: paa_arch.assignment_id,
886: paa_arch.tax_unit_id,
887: paf.effective_end_date
888: FROM per_assignments_f paf,
889: pay_assignment_actions paa_arch,
890: pay_population_ranges ppr
891: WHERE paa_arch.action_status = ''C''
892: AND paa_arch.payroll_action_id + 0 = ' || l_eoy_payroll_action_id || '
893: AND paa_arch.assignment_id = paf.assignment_id

Line 916: pay_assignment_actions paa_arch

912: paa_arch.assignment_id,
913: paa_arch.tax_unit_id,
914: paf.effective_end_date
915: FROM per_assignments_f paf,
916: pay_assignment_actions paa_arch
917: WHERE paa_arch.action_status = ''C''
918: AND paa_arch.payroll_action_id + 0 = ' || l_eoy_payroll_action_id || '
919: AND paa_arch.assignment_id = paf.assignment_id
920: AND paf.effective_start_date = (select max(paf2.effective_start_date)

Line 967: select pay_assignment_actions_s.nextval

963: hr_utility.trace('Before inserting the action record');
964:
965: hr_utility.set_location('procpyr',3);
966:
967: select pay_assignment_actions_s.nextval
968: into lockingactid
969: from dual;
970:
971: -- insert the action record.

Line 974: -- Update serial_numbrt of Pay_assignment_actions with the

970:
971: -- insert the action record.
972: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
973:
974: -- Update serial_numbrt of Pay_assignment_actions with the
975: -- assignment_action_id .
976: update pay_assignment_actions
977: set serial_number = lockedactid
978: where assignment_action_id = lockingactid;

Line 976: update pay_assignment_actions

972: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
973:
974: -- Update serial_numbrt of Pay_assignment_actions with the
975: -- assignment_action_id .
976: update pay_assignment_actions
977: set serial_number = lockedactid
978: where assignment_action_id = lockingactid;
979: end if;
980: end loop;

Line 1026: from pay_assignment_actions paa,

1022: sqlstr :=
1023: 'select paa1.rowid
1024: /* we need the row id of the assignment actions
1025: that are created by PYUGEN */
1026: from pay_assignment_actions paa,
1027: pay_assignment_actions paa1, /* PYUGEN assignment action */
1028: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
1029: where ppa1.payroll_action_id = :pactid
1030: and paa1.payroll_action_id = ppa1.payroll_action_id

Line 1027: pay_assignment_actions paa1, /* PYUGEN assignment action */

1023: 'select paa1.rowid
1024: /* we need the row id of the assignment actions
1025: that are created by PYUGEN */
1026: from pay_assignment_actions paa,
1027: pay_assignment_actions paa1, /* PYUGEN assignment action */
1028: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
1029: where ppa1.payroll_action_id = :pactid
1030: and paa1.payroll_action_id = ppa1.payroll_action_id
1031: and paa.assignment_action_id = paa1.serial_number

Line 1197: FROM pay_assignment_actions

1193: p_city_state_zip out nocopy varchar2) IS
1194:
1195: CURSOR c_person_id IS
1196: SELECT to_number(serial_number)
1197: FROM pay_assignment_actions
1198: WHERE assignment_action_id = p_fed_aaid;
1199:
1200: addr pay_us_get_item_data_pkg.person_name_address;
1201:

Line 1412: PAY_ASSIGNMENT_ACTIONS PAA, --PYUGEN

1408: v1099r.defferal_year defferal_year,
1409: v1099r.irr_amount irr_amount, -- Bug 11906843
1410: paa.tax_unit_id -- Added for #8239671
1411: from
1412: PAY_ASSIGNMENT_ACTIONS PAA, --PYUGEN
1413: PAY_PAYROLL_ACTIONS PPA, --PYUGEN
1414: PAY_US_WAGES_1099r_v v1099r
1415: WHERE
1416: paa.assignment_action_id = p_asg_actid

Line 1426: pay_assignment_actions paa

1422: SELECT ppa.legislative_parameters,
1423: fnd_date.canonical_to_date(pay_1099r_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters)),
1424: pay_1099r_pkg.get_parameter('PRINT_INSTRUCTION',ppa.legislative_parameters)
1425: FROM pay_payroll_actions ppa,
1426: pay_assignment_actions paa
1427: WHERE paa.assignment_action_id = asg_actid
1428: and ppa.payroll_action_id = paa.payroll_action_id;
1429:
1430: l_assignment_action_id number;