APPS.PAY_US_1099R_MAG_REPORTING dependencies on PER_ALL_ASSIGNMENTS_F

Line 325: per_all_assignments_f paf,

321: per_all_people_f ppf,
322: ff_user_entities ffue,
323: ff_archive_items ffai,
324: pay_action_interlocks pai,
325: per_all_assignments_f paf,
326: pay_assignment_actions paa,
327: pay_payroll_actions ppa
328: where pai.locking_action_id = paa.assignment_action_id
329: and ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value

Line 368: per_all_assignments_f paf,

364: per_all_people_f ppf,
365: ff_user_entities ffue,
366: ff_archive_items ffai,
367: pay_action_interlocks pai,
368: per_all_assignments_f paf,
369: pay_assignment_actions paa,
370: pay_payroll_actions ppa
371: where pai.locking_action_id = paa.assignment_action_id
372: and ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value

Line 420: per_all_assignments_f paf,

416: per_all_people_f ppf,
417: ff_user_entities ffue,
418: ff_archive_items ffai,
419: pay_action_interlocks pai,
420: per_all_assignments_f paf,
421: pay_assignment_actions paa,
422: pay_payroll_actions ppa,
423: pay_us_states pus
424: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value

Line 468: per_all_assignments_f paf,

464: per_all_people_f ppf,
465: ff_user_entities ffue,
466: ff_archive_items ffai,
467: pay_action_interlocks pai,
468: per_all_assignments_f paf,
469: pay_assignment_actions paa,
470: pay_payroll_actions ppa,
471: pay_us_states pus
472: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value

Line 634: per_all_assignments_f SS,

630: 'DATE_EARNED=C', fnd_date.date_to_canonical( pay_magtape_generic.date_earned (PA.effective_date, AA.assignment_id)),
631: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
632: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
633: FROM per_all_people_f PE,
634: per_all_assignments_f SS,
635: pay_action_interlocks AI,
636: pay_assignment_actions AA,
637: pay_payroll_actions PA
638: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value