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 PER_ASSIGNMENTS_F

Line 173: l_org_id per_assignments_f.organization_id%type;

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;
177: l_state_code pay_us_states.state_code%type;

Line 174: l_loc_id per_assignments_f.location_id%type;

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;
177: l_state_code pay_us_states.state_code%type;
178: l_asg_set_id number;

Line 175: l_per_id per_assignments_f.person_id%type;

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;
177: l_state_code pay_us_states.state_code%type;
178: l_asg_set_id number;
179: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

Line 234: FROM per_assignments_f paf,

230: SELECT paa_arch.assignment_action_id,
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

Line 241: from per_assignments_f paf2

237: AND paa_arch.action_status = 'C'
238: AND paf.PERSON_ID = l_per_id
239: AND paa_arch.assignment_id = paf.assignment_id
240: AND paf.effective_start_date = (select max(paf2.effective_start_date)
241: from per_assignments_f paf2
242: where paf2.assignment_id = paf.assignment_id
243: and paf2.effective_start_date <= l_session_date)
244: AND paf.effective_end_date >= l_eoy_start_date
245: AND paf.assignment_type = 'E'

Line 344: FROM per_assignments_f paf,

340: 'SELECT paa_arch.assignment_action_id,
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 || '

Line 352: from per_assignments_f paf2

348: AND paa_arch.payroll_action_id +0= ' || l_eoy_payroll_action_id || '
349: AND paa_arch.assignment_id = paf.assignment_id
350: AND paf.effective_start_date =
351: (select max(paf2.effective_start_date)
352: from per_assignments_f paf2
353: where paf2.assignment_id = paf.assignment_id
354: and paf2.effective_start_date <= ''' || l_session_date || ''')
355: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
356: AND paf.assignment_type = ''E''

Line 369: FROM per_assignments_f paf,

365: 'SELECT paa_arch.assignment_action_id,
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

Line 376: from per_assignments_f paf2

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 =
375: (select max(paf2.effective_start_date)
376: from per_assignments_f paf2
377: where paf2.assignment_id = paf.assignment_id
378: and paf2.effective_start_date <= ''' || l_session_date || ''')
379: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
380: AND paf.assignment_type = ''E''

Line 448: per_assignments_f paf,

444: paa_arch.assignment_id,
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 || '

Line 461: from per_assignments_f paf2

457: and paf.effective_end_date
458: AND paf.location_id = ' || l_loc_id || '
459: AND paf.effective_start_date =
460: (select max(paf2.effective_start_date)
461: from per_assignments_f paf2
462: where paf2.assignment_id = paf.assignment_id
463: and paf2.effective_start_date <= ''' || l_session_date || ''')
464: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
465: AND paf.assignment_type = ''E''

Line 478: per_assignments_f paf,

474: paa_arch.assignment_id,
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''

Line 490: from per_assignments_f paf2

486: and paf.effective_end_date
487: AND paf.location_id = ' || l_loc_id || '
488: AND paf.effective_start_date =
489: (select max(paf2.effective_start_date)
490: from per_assignments_f paf2
491: where paf2.assignment_id = paf.assignment_id
492: and paf2.effective_start_date <= ''' || l_session_date || ''' )
493: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
494: AND paf.assignment_type = ''E''

Line 561: per_assignments_f paf,

557: paa_arch.assignment_id,
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 || '

Line 574: from per_assignments_f paf2

570: AND paf.organization_id = ' || l_org_id || '
571: AND paa_arch.assignment_id = paf.assignment_id
572: AND paf.effective_start_date =
573: (select max(paf2.effective_start_date)
574: from per_assignments_f paf2
575: where paf2.assignment_id = paf.assignment_id
576: and paf2.effective_start_date <= ''' || l_session_date || ''')
577: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
578: AND paf.assignment_type = ''E''

Line 591: per_assignments_f paf,

587: paa_arch.assignment_id,
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''

Line 603: from per_assignments_f paf2

599: AND paf.organization_id = ' || l_org_id || '
600: AND paa_arch.assignment_id = paf.assignment_id
601: AND paf.effective_start_date =
602: (select max(paf2.effective_start_date)
603: from per_assignments_f paf2
604: where paf2.assignment_id = paf.assignment_id
605: and paf2.effective_start_date <= ''' || l_session_date || ''')
606: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
607: AND paf.assignment_type = ''E''

Line 744: FROM per_assignments_f paf,

740: 'SELECT paa_arch.assignment_action_id,
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''

Line 752: from per_assignments_f paf2

748: AND paa_arch.action_status = ''C''
749: AND paa_arch.assignment_id = paf.assignment_id
750: AND paf.effective_start_date =
751: (select max(paf2.effective_start_date)
752: from per_assignments_f paf2
753: where paf2.assignment_id = paf.assignment_id
754: and paf2.effective_start_date <= ''' || l_session_date || ''')
755: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
756: AND paf.assignment_type = ''E''

Line 767: FROM per_assignments_f paf,

763: 'SELECT paa_arch.assignment_action_id,
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

Line 774: from per_assignments_f paf2

770: AND paa_arch.action_status = ''C''
771: AND paa_arch.assignment_id = paf.assignment_id
772: AND paf.effective_start_date =
773: (select max(paf2.effective_start_date)
774: from per_assignments_f paf2
775: where paf2.assignment_id = paf.assignment_id
776: and paf2.effective_start_date <= ''' || l_session_date || ''')
777: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
778: AND paf.assignment_type = ''E''

Line 872: FROM per_assignments_f paf,

868: 'SELECT paa_arch.assignment_action_id,
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 || '

Line 879: from per_assignments_f paf2

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
878: AND paf.effective_start_date = (select max(paf2.effective_start_date)
879: from per_assignments_f paf2
880: where paf2.assignment_id = paf.assignment_id
881: and paf2.effective_start_date <= ''' || l_session_date || ''')
882: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
883: AND paf.assignment_type = ''E''

Line 899: FROM per_assignments_f paf,

895: 'SELECT paa_arch.assignment_action_id,
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

Line 905: from per_assignments_f paf2

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)
905: from per_assignments_f paf2
906: where paf2.assignment_id = paf.assignment_id
907: and paf2.effective_start_date <= ''' || l_session_date || ''')
908: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
909: AND paf.assignment_type = ''E''