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 197: per_all_assignments_f SS,

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

Line 217: from per_all_assignments_f paf2

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

Line 238: per_all_assignments_f SS,

234: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
235: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned
236: (PA.effective_date, AA.assignment_id))
237: from per_all_people_f PE,
238: per_all_assignments_f SS,
239: pay_assignment_actions AA,
240: pay_payroll_actions PA
241: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
242: ('TRANSFER_PAYROLL_ACTION_ID')

Line 251: from per_all_assignments_f paf2

247: and PE.person_id = SS.person_id
248: AND nvl(AA.serial_number,'0') <> 'X'
249: AND SS.effective_start_date =
250: (select max(paf2.effective_start_date)
251: from per_all_assignments_f paf2
252: where paf2.assignment_id = SS.assignment_id
253: and paf2.effective_start_date <= PA.effective_date
254: and paf2.assignment_type = 'E')
255: AND SS.effective_end_date >= PA.start_date

Line 281: per_all_assignments_f SS,

277: 'TRANSFER_REPORT_FORMAT=P', pay_magtape_generic.get_parameter_value
278: ('TRANSFER_REPORT_CATEGORY')
279: from pay_payroll_actions PA,
280: pay_assignment_actions AA,
281: per_all_assignments_f SS,
282: per_all_people_f PE,
283: ff_archive_items fai,
284: ff_user_entities fue
285: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 301: from per_all_assignments_f paf2

297: */
298: /* Added for bug 2464463 */
299: AND SS.effective_start_date =
300: (select max(paf2.effective_start_date)
301: from per_all_assignments_f paf2
302: where paf2.assignment_id = SS.assignment_id
303: and paf2.effective_start_date <= PA.effective_date
304: and paf2.assignment_type = 'E')
305: AND SS.effective_end_date >= PA.start_date

Line 522: per_all_assignments_f SS,

518: 'ASSIGNMENT_ID=C' , AA.assignment_id,
519: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
520: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id))
521: from per_all_people_f PE,
522: per_all_assignments_f SS,
523: pay_assignment_actions AA,
524: pay_payroll_actions PA
525: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
526: ('TRANSFER_PAYROLL_ACTION_ID')