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_IE_P35_MAGTAPE dependencies on PER_ASSIGNMENTS_F

Line 124: per_assignments_f asg,

120: -- Changed the cursor to reduce the cost (5042843)
121: p_sqlstr :=
122: ' SELECT distinct asg.person_id
123: FROM per_periods_of_service pos,
124: per_assignments_f asg,
125: pay_payroll_actions ppa
126: WHERE ppa.payroll_action_id = :payroll_action_id
127: AND pos.person_id = asg.person_id
128: AND pos.period_of_service_id = asg.period_of_service_id

Line 187: per_assignments_f paaf,

183: SELECT DISTINCT paa.assignment_id,paa.assignment_action_id,paa.payroll_action_id
184: FROM pay_assignment_actions paa,
185: pay_payroll_actions ppa,
186: pay_action_information pai,
187: per_assignments_f paaf,
188: pay_all_payrolls_f ppf,
189: hr_soft_coding_keyflex flex
190: WHERE paa.payroll_action_id = ppa.payroll_action_id
191: AND paa.action_status = 'C'

Line 217: AND (ppf.payroll_id in (select b.payroll_id FROM per_assignments_f a,per_assignments_f b

213: 'END_DATE'
214: ),
215: 'YYYY/MM/DD'
216: ) BETWEEN l_start_date AND l_end_date
217: AND (ppf.payroll_id in (select b.payroll_id FROM per_assignments_f a,per_assignments_f b
218: where a.payroll_id = l_payroll_id
219: and a.person_id = b.person_id
220: and a.person_id = paaf.person_id
221: --bug 6642916

Line 231: , per_assignments_f paf

227: AND ((l_assignment_set_id IS NOT NULL
228: AND (l_set_flag ='I' AND EXISTS(SELECT 1
229: FROM hr_assignment_set_amendments hasa
230: , hr_assignment_sets has
231: , per_assignments_f paf
232: --, pay_payrolls_f pay
233: --, hr_soft_coding_keyflex hflex
234: WHERE has.assignment_set_id = hasa.assignment_set_id
235: AND has.business_group_id = l_bg_id

Line 245: , per_assignments_f paf

241: --AND hflex.segment4 = l_segment4)
242: OR l_set_flag = 'E' AND NOT EXISTS(SELECT 1
243: FROM hr_assignment_set_amendments hasa
244: , hr_assignment_sets has
245: , per_assignments_f paf
246: -- , pay_payrolls_f pay
247: -- , hr_soft_coding_keyflex hflex
248: WHERE has.assignment_set_id = hasa.assignment_set_id
249: AND has.business_group_id = l_bg_id

Line 262: per_assignments_f paaf_p35,

258: AND NOT EXISTS (
259: SELECT 1
260: FROM pay_assignment_actions paa_p35,
261: pay_payroll_actions ppa_p35,
262: per_assignments_f paaf_p35,
263: pay_all_payrolls_f ppf_p35,
264: hr_soft_coding_keyflex flex_p35,
265: pay_action_interlocks plock
266: WHERE ppa_p35.report_type = 'IEP35MAG'