APPS.PAY_US_MMREF_REPORTING1 dependencies on PER_ALL_ASSIGNMENTS_F

Line 70: per_all_assignments_f

66: 02-Dec-2003 tmehra 115.16 Modified govt_mmrf_employee cursor.
67: 03-Dec-2003 tmehra 115.17 Modified govt_mmrf_employer cursor.
68: 28-DEC-2004 ahanda 115.19 Changed employee cursor for performance
69: 04-JAN-2004 ahanda 115.20 Changed per_assignments_f to
70: per_all_assignments_f
71: =============================================================================*/
72:
73: -- 'level_cnt' will allow the cursors to select function results,
74: -- whether it is a standard fuction such as to_char or a function

Line 311: per_all_assignments_f SS,

307: (PA.effective_date, AA.assignment_id)),
308: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
309: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
310: FROM per_all_people_f PE,
311: per_all_assignments_f SS,
312: pay_action_interlocks AI,
313: pay_assignment_actions AA,
314: pay_payroll_actions PA
315: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 325: from per_all_assignments_f paf2

321: AND SS.assignment_id = AA.assignment_id
322: AND PE.person_id = SS.person_id
323: AND SS.effective_start_date =
324: (select max(paf2.effective_start_date)
325: from per_all_assignments_f paf2
326: where paf2.assignment_id = SS.assignment_id
327: and paf2.effective_start_date <= PA.effective_date
328: and paf2.assignment_type = 'E')
329: AND SS.effective_end_date >= PA.start_date

Line 344: per_all_assignments_f SS,

340: (PA.effective_date, AA.assignment_id)),
341: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
342: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
343: FROM per_all_people_f PE,
344: per_all_assignments_f SS,
345: pay_action_interlocks AI,
346: pay_assignment_actions AA,
347: pay_assignment_actions paa,
348: pay_payroll_actions PA,

Line 361: from per_all_assignments_f paf2

357: AND SS.assignment_id = AA.assignment_id
358: AND PE.person_id = SS.person_id
359: AND SS.effective_start_date =
360: (select max(paf2.effective_start_date)
361: from per_all_assignments_f paf2
362: where paf2.assignment_id = SS.assignment_id
363: and paf2.effective_start_date <= PA.effective_date
364: and paf2.assignment_type = 'E')
365: AND SS.effective_end_date >= PA.start_date

Line 392: per_all_assignments_f SS,

388: (PA.effective_date, AA.assignment_id)),
389: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
390: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
391: FROM per_all_people_f PE,
392: per_all_assignments_f SS,
393: pay_action_interlocks AI,
394: pay_assignment_actions AA,
395: pay_payroll_actions PA
396: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 406: from per_all_assignments_f paf2

402: AND SS.assignment_id = AA.assignment_id
403: AND PE.person_id = SS.person_id
404: AND SS.effective_start_date =
405: (select max(paf2.effective_start_date)
406: from per_all_assignments_f paf2
407: where paf2.assignment_id = SS.assignment_id
408: and paf2.effective_start_date <= PA.effective_date
409: and paf2.assignment_type = 'E')
410: AND SS.effective_end_date >= PA.start_date

Line 481: per_all_assignments_f SS,

477: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
478: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id,
479: 'TAX_UNIT_ID=C',AA.TAX_UNIT_ID
480: FROM per_all_people_f PE,
481: per_all_assignments_f SS,
482: pay_action_interlocks AI,
483: pay_assignment_actions AA,
484: pay_payroll_actions PA
485: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 495: from per_all_assignments_f paf2

491: AND SS.assignment_id = AA.assignment_id
492: AND PE.person_id = SS.person_id
493: AND SS.effective_start_date =
494: (select max(paf2.effective_start_date)
495: from per_all_assignments_f paf2
496: where paf2.assignment_id = SS.assignment_id
497: and paf2.effective_start_date <= PA.effective_date
498: and paf2.assignment_type = 'E')
499: AND SS.effective_end_date >= PA.start_date