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 123: FROM PAY_ASSIGNMENT_ACTIONS paa_arch,

119: -- hr_us_w2_rep.initialize_assignment_set(ln_assign_set);
120:
121: sqlstr :=
122: 'SELECT distinct to_number(paa_arch.serial_number)
123: FROM PAY_ASSIGNMENT_ACTIONS paa_arch,
124: PAY_PAYROLL_ACTIONS ppa_arch
125: WHERE :pactid is not null
126: AND ppa_arch.report_type = ''YREND''
127: AND to_char(ppa_arch.effective_date,''YYYY'')= '''||ln_year||'''

Line 172: l_gre_id pay_assignment_actions.tax_unit_id%type;

168:
169: l_procedure_name VARCHAR2(100);
170: l_session_date date;
171: l_year number ;
172: l_gre_id pay_assignment_actions.tax_unit_id%type;
173: l_org_id per_assignments_f.organization_id%type;
174: l_loc_id per_assignments_f.location_id%type;
175: l_per_id per_assignments_f.person_id%type;
176: l_ssn per_people_f.national_identifier%type;

Line 235: pay_assignment_actions paa_arch

231: paa_arch.assignment_id,
232: paa_arch.tax_unit_id,
233: paf.effective_end_date
234: FROM per_assignments_f paf,
235: pay_assignment_actions paa_arch
236: WHERE paa_arch.payroll_action_id = l_eoy_payroll_action_id
237: AND paa_arch.action_status = 'C'
238: AND paf.PERSON_ID = l_per_id
239: AND paa_arch.assignment_id = paf.assignment_id

Line 345: pay_assignment_actions paa_arch,

341: paa_arch.assignment_id,
342: paa_arch.tax_unit_id,
343: paf.effective_end_date
344: FROM per_assignments_f paf,
345: pay_assignment_actions paa_arch,
346: pay_population_ranges ppr
347: WHERE paa_arch.action_status = ''C''
348: AND paa_arch.payroll_action_id +0= ' || l_eoy_payroll_action_id || '
349: AND paa_arch.assignment_id = paf.assignment_id

Line 370: pay_assignment_actions paa_arch

366: paa_arch.assignment_id,
367: paa_arch.tax_unit_id,
368: paf.effective_end_date
369: FROM per_assignments_f paf,
370: pay_assignment_actions paa_arch
371: WHERE paa_arch.action_status = ''C''
372: AND paa_arch.payroll_action_id +0= ' || l_eoy_payroll_action_id || '
373: AND paa_arch.assignment_id = paf.assignment_id
374: AND paf.effective_start_date =

Line 418: select pay_assignment_actions_s.nextval

414: -- for each assignment/pre-payment/reversal).
415: hr_utility.set_location(l_procedure_name, 25);
416: hr_utility.trace('Before inserting the action record');
417:
418: select pay_assignment_actions_s.nextval
419: into lockingactid
420: from dual;
421:
422: -- insert the action record.

Line 425: -- Update serial_numbrt of Pay_assignment_actions with the

421:
422: -- insert the action record.
423: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
424:
425: -- Update serial_numbrt of Pay_assignment_actions with the
426: -- assignment_action_id .
427: update pay_assignment_actions
428: set serial_number = lockedactid
429: where assignment_action_id = lockingactid;

Line 427: update pay_assignment_actions

423: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
424:
425: -- Update serial_numbrt of Pay_assignment_actions with the
426: -- assignment_action_id .
427: update pay_assignment_actions
428: set serial_number = lockedactid
429: where assignment_action_id = lockingactid;
430: end if;
431: end loop;

Line 449: pay_assignment_actions paa_arch,

445: paa_arch.tax_unit_id,
446: paf.effective_end_date
447: FROM per_periods_of_service pps,
448: per_assignments_f paf,
449: pay_assignment_actions paa_arch,
450: pay_population_ranges ppr
451: /* disabling the index for performance reason */
452: WHERE paa_arch.payroll_action_id + 0 = ' || l_eoy_payroll_action_id || '
453: AND paa_arch.action_status = ''C''

Line 479: pay_assignment_actions paa_arch

475: paa_arch.tax_unit_id,
476: paf.effective_end_date
477: FROM per_periods_of_service pps,
478: per_assignments_f paf,
479: pay_assignment_actions paa_arch
480: /* disabling the index for performance reason */
481: WHERE paa_arch.payroll_action_id + 0 = ' || l_eoy_payroll_action_id || '
482: AND paa_arch.action_status = ''C''
483: AND paa_arch.assignment_id = paf.assignment_id

Line 529: select pay_assignment_actions_s.nextval

525:
526: hr_utility.set_location(l_procedure_name, 45);
527: hr_utility.trace('Before inserting the action record');
528:
529: select pay_assignment_actions_s.nextval
530: into lockingactid
531: from dual;
532:
533: -- insert the action record.

Line 536: -- Update serial_numbrt of Pay_assignment_actions with the

532:
533: -- insert the action record.
534: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
535:
536: -- Update serial_numbrt of Pay_assignment_actions with the
537: -- assignment_action_id .
538: update pay_assignment_actions
539: set serial_number = lockedactid
540: where assignment_action_id = lockingactid;

Line 538: update pay_assignment_actions

534: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
535:
536: -- Update serial_numbrt of Pay_assignment_actions with the
537: -- assignment_action_id .
538: update pay_assignment_actions
539: set serial_number = lockedactid
540: where assignment_action_id = lockingactid;
541: end if;
542: end loop;

Line 562: pay_assignment_actions paa_arch,

558: paa_arch.tax_unit_id,
559: paf.effective_end_date
560: FROM per_periods_of_service pps,
561: per_assignments_f paf,
562: pay_assignment_actions paa_arch,
563: pay_population_ranges ppr
564: /* disabling the index for performance reason */
565: WHERE paa_arch.payroll_action_id +0 = ' || l_eoy_payroll_action_id || '
566: AND paa_arch.action_status = ''C''

Line 592: pay_assignment_actions paa_arch

588: paa_arch.tax_unit_id,
589: paf.effective_end_date
590: FROM per_periods_of_service pps,
591: per_assignments_f paf,
592: pay_assignment_actions paa_arch
593: /* disabling the index for performance reason */
594: WHERE paa_arch.payroll_action_id +0 = ' || l_eoy_payroll_action_id || '
595: AND paa_arch.action_status = ''C''
596: AND nvl(pps.final_process_date,''' || l_session_date || ''')

Line 643: select pay_assignment_actions_s.nextval

639:
640: hr_utility.set_location(l_procedure_name, 90);
641: hr_utility.trace('Before inserting the action record');
642:
643: select pay_assignment_actions_s.nextval
644: into lockingactid
645: from dual;
646:
647: -- insert the action record.

Line 650: -- Update serial_numbrt of Pay_assignment_actions with the

646:
647: -- insert the action record.
648: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
649:
650: -- Update serial_numbrt of Pay_assignment_actions with the
651: -- assignment_action_id .
652: update pay_assignment_actions
653: set serial_number = lockedactid
654: where assignment_action_id = lockingactid;

Line 652: update pay_assignment_actions

648: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
649:
650: -- Update serial_numbrt of Pay_assignment_actions with the
651: -- assignment_action_id .
652: update pay_assignment_actions
653: set serial_number = lockedactid
654: where assignment_action_id = lockingactid;
655: end if;
656: end loop;

Line 704: select pay_assignment_actions_s.nextval

700:
701: hr_utility.set_location(l_procedure_name, 110);
702: hr_utility.trace('Before inserting the action record');
703:
704: select pay_assignment_actions_s.nextval
705: into lockingactid
706: from dual;
707:
708: -- insert the action record.

Line 711: -- Update serial_numbrt of Pay_assignment_actions with the

707:
708: -- insert the action record.
709: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
710:
711: -- Update serial_numbrt of Pay_assignment_actions with the
712: -- assignment_action_id .
713: update pay_assignment_actions
714: set serial_number = lockedactid
715: where assignment_action_id = lockingactid;

Line 713: update pay_assignment_actions

709: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
710:
711: -- Update serial_numbrt of Pay_assignment_actions with the
712: -- assignment_action_id .
713: update pay_assignment_actions
714: set serial_number = lockedactid
715: where assignment_action_id = lockingactid;
716: end if;
717: end loop;

Line 745: pay_assignment_actions paa_arch,

741: paa_arch.assignment_id,
742: paa_arch.tax_unit_id,
743: paf.effective_end_date
744: FROM per_assignments_f paf,
745: pay_assignment_actions paa_arch,
746: pay_population_ranges ppr
747: WHERE paa_arch.payroll_action_id +0 = ' || l_eoy_payroll_action_id || '
748: AND paa_arch.action_status = ''C''
749: AND paa_arch.assignment_id = paf.assignment_id

Line 768: pay_assignment_actions paa_arch

764: paa_arch.assignment_id,
765: paa_arch.tax_unit_id,
766: paf.effective_end_date
767: FROM per_assignments_f paf,
768: pay_assignment_actions paa_arch
769: WHERE paa_arch.payroll_action_id +0 = ' || l_eoy_payroll_action_id || '
770: AND paa_arch.action_status = ''C''
771: AND paa_arch.assignment_id = paf.assignment_id
772: AND paf.effective_start_date =

Line 842: select pay_assignment_actions_s.nextval

838:
839: hr_utility.set_location(l_procedure_name, 220);
840: hr_utility.trace('Before inserting the action record');
841:
842: select pay_assignment_actions_s.nextval
843: into lockingactid
844: from dual;
845:
846: -- insert the action record.

Line 849: -- Update serial_numbrt of Pay_assignment_actions with the

845:
846: -- insert the action record.
847: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
848:
849: -- Update serial_numbrt of Pay_assignment_actions with the
850: -- assignment_action_id .
851: update pay_assignment_actions
852: set serial_number = lockedactid
853: where assignment_action_id = lockingactid;

Line 851: update pay_assignment_actions

847: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
848:
849: -- Update serial_numbrt of Pay_assignment_actions with the
850: -- assignment_action_id .
851: update pay_assignment_actions
852: set serial_number = lockedactid
853: where assignment_action_id = lockingactid;
854: end if;
855: end loop;

Line 873: pay_assignment_actions paa_arch,

869: paa_arch.assignment_id,
870: paa_arch.tax_unit_id,
871: paf.effective_end_date
872: FROM per_assignments_f paf,
873: pay_assignment_actions paa_arch,
874: pay_population_ranges ppr
875: WHERE paa_arch.action_status = ''C''
876: AND paa_arch.payroll_action_id + 0 = ' || l_eoy_payroll_action_id || '
877: AND paa_arch.assignment_id = paf.assignment_id

Line 900: pay_assignment_actions paa_arch

896: paa_arch.assignment_id,
897: paa_arch.tax_unit_id,
898: paf.effective_end_date
899: FROM per_assignments_f paf,
900: pay_assignment_actions paa_arch
901: WHERE paa_arch.action_status = ''C''
902: AND paa_arch.payroll_action_id + 0 = ' || l_eoy_payroll_action_id || '
903: AND paa_arch.assignment_id = paf.assignment_id
904: AND paf.effective_start_date = (select max(paf2.effective_start_date)

Line 951: select pay_assignment_actions_s.nextval

947: hr_utility.trace('Before inserting the action record');
948:
949: hr_utility.set_location('procpyr',3);
950:
951: select pay_assignment_actions_s.nextval
952: into lockingactid
953: from dual;
954:
955: -- insert the action record.

Line 958: -- Update serial_numbrt of Pay_assignment_actions with the

954:
955: -- insert the action record.
956: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
957:
958: -- Update serial_numbrt of Pay_assignment_actions with the
959: -- assignment_action_id .
960: update pay_assignment_actions
961: set serial_number = lockedactid
962: where assignment_action_id = lockingactid;

Line 960: update pay_assignment_actions

956: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
957:
958: -- Update serial_numbrt of Pay_assignment_actions with the
959: -- assignment_action_id .
960: update pay_assignment_actions
961: set serial_number = lockedactid
962: where assignment_action_id = lockingactid;
963: end if;
964: end loop;

Line 1010: from pay_assignment_actions paa,

1006: sqlstr :=
1007: 'select paa1.rowid
1008: /* we need the row id of the assignment actions
1009: that are created by PYUGEN */
1010: from pay_assignment_actions paa,
1011: pay_assignment_actions paa1, /* PYUGEN assignment action */
1012: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
1013: where ppa1.payroll_action_id = :pactid
1014: and paa1.payroll_action_id = ppa1.payroll_action_id

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

1007: 'select paa1.rowid
1008: /* we need the row id of the assignment actions
1009: that are created by PYUGEN */
1010: from pay_assignment_actions paa,
1011: pay_assignment_actions paa1, /* PYUGEN assignment action */
1012: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
1013: where ppa1.payroll_action_id = :pactid
1014: and paa1.payroll_action_id = ppa1.payroll_action_id
1015: and paa.assignment_action_id = paa1.serial_number

Line 1181: FROM pay_assignment_actions

1177: p_city_state_zip out nocopy varchar2) IS
1178:
1179: CURSOR c_person_id IS
1180: SELECT to_number(serial_number)
1181: FROM pay_assignment_actions
1182: WHERE assignment_action_id = p_fed_aaid;
1183:
1184: addr pay_us_get_item_data_pkg.person_name_address;
1185:

Line 1394: PAY_ASSIGNMENT_ACTIONS PAA, --PYUGEN

1390: v1099r.total_ee_contributions tot_ee_contr,
1391: nvl(hr_us_w2_rep.get_per_item(v1099r.assignment_action_id, 'A_DISTRIBUTION_CODE_FOR_1099R'),'7') ee_distribution_code,
1392: v1099r.defferal_year defferal_year
1393: from
1394: PAY_ASSIGNMENT_ACTIONS PAA, --PYUGEN
1395: PAY_PAYROLL_ACTIONS PPA, --PYUGEN
1396: PAY_US_WAGES_1099r_v v1099r
1397: WHERE
1398: paa.assignment_action_id = p_asg_actid

Line 1408: pay_assignment_actions paa

1404: SELECT ppa.legislative_parameters,
1405: fnd_date.canonical_to_date(pay_1099r_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters)),
1406: pay_1099r_pkg.get_parameter('PRINT_INSTRUCTION',ppa.legislative_parameters)
1407: FROM pay_payroll_actions ppa,
1408: pay_assignment_actions paa
1409: WHERE paa.assignment_action_id = asg_actid
1410: and ppa.payroll_action_id = paa.payroll_action_id;
1411:
1412: l_assignment_action_id number;