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 189: l_org_id per_assignments_f.organization_id%type;

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

Line 190: l_loc_id per_assignments_f.location_id%type;

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

Line 191: l_per_id per_assignments_f.person_id%type;

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;
193: l_state_code pay_us_states.state_code%type;
194: l_asg_set_id number;
195: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

Line 250: FROM per_assignments_f paf,

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

Line 257: from per_assignments_f paf2

253: AND paa_arch.action_status = 'C'
254: AND paf.PERSON_ID = l_per_id
255: AND paa_arch.assignment_id = paf.assignment_id
256: AND paf.effective_start_date = (select max(paf2.effective_start_date)
257: from per_assignments_f paf2
258: where paf2.assignment_id = paf.assignment_id
259: and paf2.effective_start_date <= l_session_date)
260: AND paf.effective_end_date >= l_eoy_start_date
261: AND paf.assignment_type = 'E'

Line 360: FROM per_assignments_f paf,

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

Line 368: from per_assignments_f paf2

364: AND paa_arch.payroll_action_id +0= ' || l_eoy_payroll_action_id || '
365: AND paa_arch.assignment_id = paf.assignment_id
366: AND paf.effective_start_date =
367: (select max(paf2.effective_start_date)
368: from per_assignments_f paf2
369: where paf2.assignment_id = paf.assignment_id
370: and paf2.effective_start_date <= ''' || l_session_date || ''')
371: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
372: AND paf.assignment_type = ''E''

Line 385: FROM per_assignments_f paf,

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

Line 392: from per_assignments_f paf2

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 =
391: (select max(paf2.effective_start_date)
392: from per_assignments_f paf2
393: where paf2.assignment_id = paf.assignment_id
394: and paf2.effective_start_date <= ''' || l_session_date || ''')
395: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
396: AND paf.assignment_type = ''E''

Line 464: per_assignments_f paf,

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

Line 477: from per_assignments_f paf2

473: and paf.effective_end_date
474: AND paf.location_id = ' || l_loc_id || '
475: AND paf.effective_start_date =
476: (select max(paf2.effective_start_date)
477: from per_assignments_f paf2
478: where paf2.assignment_id = paf.assignment_id
479: and paf2.effective_start_date <= ''' || l_session_date || ''')
480: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
481: AND paf.assignment_type = ''E''

Line 494: per_assignments_f paf,

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

Line 506: from per_assignments_f paf2

502: and paf.effective_end_date
503: AND paf.location_id = ' || l_loc_id || '
504: AND paf.effective_start_date =
505: (select max(paf2.effective_start_date)
506: from per_assignments_f paf2
507: where paf2.assignment_id = paf.assignment_id
508: and paf2.effective_start_date <= ''' || l_session_date || ''' )
509: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
510: AND paf.assignment_type = ''E''

Line 577: per_assignments_f paf,

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

Line 590: from per_assignments_f paf2

586: AND paf.organization_id = ' || l_org_id || '
587: AND paa_arch.assignment_id = paf.assignment_id
588: AND paf.effective_start_date =
589: (select max(paf2.effective_start_date)
590: from per_assignments_f paf2
591: where paf2.assignment_id = paf.assignment_id
592: and paf2.effective_start_date <= ''' || l_session_date || ''')
593: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
594: AND paf.assignment_type = ''E''

Line 607: per_assignments_f paf,

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

Line 619: from per_assignments_f paf2

615: AND paf.organization_id = ' || l_org_id || '
616: AND paa_arch.assignment_id = paf.assignment_id
617: AND paf.effective_start_date =
618: (select max(paf2.effective_start_date)
619: from per_assignments_f paf2
620: where paf2.assignment_id = paf.assignment_id
621: and paf2.effective_start_date <= ''' || l_session_date || ''')
622: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
623: AND paf.assignment_type = ''E''

Line 760: FROM per_assignments_f paf,

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

Line 768: from per_assignments_f paf2

764: AND paa_arch.action_status = ''C''
765: AND paa_arch.assignment_id = paf.assignment_id
766: AND paf.effective_start_date =
767: (select max(paf2.effective_start_date)
768: from per_assignments_f paf2
769: where paf2.assignment_id = paf.assignment_id
770: and paf2.effective_start_date <= ''' || l_session_date || ''')
771: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
772: AND paf.assignment_type = ''E''

Line 783: FROM per_assignments_f paf,

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

Line 790: from per_assignments_f paf2

786: AND paa_arch.action_status = ''C''
787: AND paa_arch.assignment_id = paf.assignment_id
788: AND paf.effective_start_date =
789: (select max(paf2.effective_start_date)
790: from per_assignments_f paf2
791: where paf2.assignment_id = paf.assignment_id
792: and paf2.effective_start_date <= ''' || l_session_date || ''')
793: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
794: AND paf.assignment_type = ''E''

Line 888: FROM per_assignments_f paf,

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

Line 895: from per_assignments_f paf2

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
894: AND paf.effective_start_date = (select max(paf2.effective_start_date)
895: from per_assignments_f paf2
896: where paf2.assignment_id = paf.assignment_id
897: and paf2.effective_start_date <= ''' || l_session_date || ''')
898: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
899: AND paf.assignment_type = ''E''

Line 915: FROM per_assignments_f paf,

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

Line 921: from per_assignments_f paf2

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)
921: from per_assignments_f paf2
922: where paf2.assignment_id = paf.assignment_id
923: and paf2.effective_start_date <= ''' || l_session_date || ''')
924: AND paf.effective_end_date >= ''' || l_eoy_start_date || '''
925: AND paf.assignment_type = ''E''