APPS.PAY_US_1099R_MAG_REPORTING dependencies on PER_ALL_ASSIGNMENTS_F

Line 331: per_all_assignments_f paf,

327: per_all_people_f ppf,
328: ff_user_entities ffue,
329: ff_archive_items ffai,
330: pay_action_interlocks pai,
331: per_all_assignments_f paf,
332: pay_assignment_actions paa,
333: pay_payroll_actions ppa
334: where pai.locking_action_id = paa.assignment_action_id
335: and ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value

Line 374: per_all_assignments_f paf,

370: per_all_people_f ppf,
371: ff_user_entities ffue,
372: ff_archive_items ffai,
373: pay_action_interlocks pai,
374: per_all_assignments_f paf,
375: pay_assignment_actions paa,
376: pay_payroll_actions ppa
377: where pai.locking_action_id = paa.assignment_action_id
378: and ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value

Line 426: per_all_assignments_f paf,

422: per_all_people_f ppf,
423: ff_user_entities ffue,
424: ff_archive_items ffai,
425: pay_action_interlocks pai,
426: per_all_assignments_f paf,
427: pay_assignment_actions paa,
428: pay_payroll_actions ppa,
429: pay_us_states pus
430: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value

Line 474: per_all_assignments_f paf,

470: per_all_people_f ppf,
471: ff_user_entities ffue,
472: ff_archive_items ffai,
473: pay_action_interlocks pai,
474: per_all_assignments_f paf,
475: pay_assignment_actions paa,
476: pay_payroll_actions ppa,
477: pay_us_states pus
478: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value

Line 645: per_all_assignments_f SS,

641: 'DATE_EARNED=C', fnd_date.date_to_canonical( pay_magtape_generic.date_earned (PA.effective_date, AA.assignment_id)),
642: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
643: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
644: FROM per_all_people_f PE,
645: per_all_assignments_f SS,
646: pay_action_interlocks AI,
647: pay_assignment_actions AA,
648: pay_payroll_actions PA
649: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value