DBA Data[Home] [Help]

APPS.PAY_US_1099R_MAG_REPORTING dependencies on PER_ALL_PEOPLE_F

Line 321: per_all_people_f ppf,

317: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
318: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
319: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
320: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
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,

Line 364: per_all_people_f ppf,

360: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
361: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
362: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
363: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
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,

Line 416: per_all_people_f ppf,

412: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
413: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
414: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
415: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
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,

Line 464: per_all_people_f ppf,

460: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
461: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
462: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
463: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
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,

Line 633: FROM per_all_people_f PE,

629: 'ASSIGNMENT_ID=C', AA.assignment_id,
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