eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_SQWL_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 195: per_all_assignments_f SS,

191: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
192: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned
193: (PA.effective_date, AA.assignment_id))
194: from per_all_people_f PE,
195: per_all_assignments_f SS,
196: pay_assignment_actions AA,
197: pay_payroll_actions PA
198: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
199: ('TRANSFER_PAYROLL_ACTION_ID')

Line 215: from per_all_assignments_f paf2

211:
212: /* Added for bug 2464463 */
213: AND SS.effective_start_date =
214: (select max(paf2.effective_start_date)
215: from per_all_assignments_f paf2
216: where paf2.assignment_id = SS.assignment_id
217: and paf2.effective_start_date <= PA.effective_date
218: and paf2.assignment_type = 'E')
219: AND SS.effective_end_date >= PA.start_date

Line 244: per_all_assignments_f SS,

240: 'TRANSFER_REPORT_FORMAT=P', pay_magtape_generic.get_parameter_value
241: ('TRANSFER_REPORT_CATEGORY')
242: from pay_payroll_actions PA,
243: pay_assignment_actions AA,
244: per_all_assignments_f SS,
245: per_all_people_f PE,
246: ff_archive_items fai,
247: ff_user_entities fue
248: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 264: from per_all_assignments_f paf2

260: */
261: /* Added for bug 2464463 */
262: AND SS.effective_start_date =
263: (select max(paf2.effective_start_date)
264: from per_all_assignments_f paf2
265: where paf2.assignment_id = SS.assignment_id
266: and paf2.effective_start_date <= PA.effective_date
267: and paf2.assignment_type = 'E')
268: AND SS.effective_end_date >= PA.start_date

Line 483: per_all_assignments_f SS,

479: 'ASSIGNMENT_ID=C' , AA.assignment_id,
480: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
481: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id))
482: from per_all_people_f PE,
483: per_all_assignments_f SS,
484: pay_assignment_actions AA,
485: pay_payroll_actions PA
486: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
487: ('TRANSFER_PAYROLL_ACTION_ID')