DBA Data[Home] [Help]

APPS.PAY_US_1099R_MAG_REPORTING dependencies on PER_ALL_PEOPLE_F

Line 327: per_all_people_f ppf,

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

Line 370: per_all_people_f ppf,

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

Line 422: per_all_people_f ppf,

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

Line 470: per_all_people_f ppf,

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

Line 644: FROM per_all_people_f PE,

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