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_SIMULATOR_SS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 243: , pay_assignment_actions paa

239: (p_start_date IN date
240: , p_end_date IN date) IS
241: SELECT 1
242: FROM pay_payroll_actions ppa
243: , pay_assignment_actions paa
244: WHERE ppa.payroll_action_id = paa.payroll_action_id
245: AND paa.assignment_id = p_assignment_id
246: AND ppa.action_type IN ('C', 'P', 'U')
247: AND nvl(ppa.date_earned,ppa.effective_date)

Line 572: , pay_assignment_actions paa

568: (p_start_date IN date
569: , p_end_date IN date) IS
570: SELECT 1
571: FROM pay_payroll_actions ppa
572: , pay_assignment_actions paa
573: WHERE ppa.payroll_action_id = paa.payroll_action_id
574: AND paa.assignment_id = p_assignment_id
575: AND ppa.action_type IN ('C', 'P', 'U')
576: AND nvl(ppa.date_earned,ppa.effective_date)

Line 603: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null

599: as2.effective_start_date and as2.effective_end_date
600: and pbg.business_group_id = asg.business_group_id
601: and not exists (
602: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
603: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
604: from pay_action_classifications acl,
605: pay_assignment_actions ac2,
606: pay_payroll_actions pa2,
607: per_all_assignments_f as2

Line 605: pay_assignment_actions ac2,

601: and not exists (
602: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
603: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
604: from pay_action_classifications acl,
605: pay_assignment_actions ac2,
606: pay_payroll_actions pa2,
607: per_all_assignments_f as2
608: where as2.period_of_service_id = pos.period_of_service_id
609: and ac2.assignment_id = as2.assignment_id