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_NL_TAXOFFICE_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 233: -- ,per_all_assignments_f paa

229: per_people_f pap
230: ,per_assignments_f paa
231: ,pay_all_payrolls_f ppf
232: -- per_all_people_f pap Performance fix 5042871
233: -- ,per_all_assignments_f paa
234: WHERE pap.business_group_id = lp_business_group_id
235: and pap.person_id = paa.person_id
236: and paa.person_id BETWEEN lp_start_person_id AND lp_end_person_id
237: and lp_Tax_Year_End_Date between pap.effective_start_date and pap.effective_end_date

Line 241: FROM per_all_assignments_f asg

237: and lp_Tax_Year_End_Date between pap.effective_start_date and pap.effective_end_date
238: and paa.effective_start_date =
239: (
240: SELECT MIN(asg.effective_start_date)
241: FROM per_all_assignments_f asg
242: WHERE asg.assignment_id = paa.assignment_id
243: and asg.payroll_id is not NULL
244: and asg.effective_start_date <= lp_Tax_Year_End_Date
245: and nvl(asg.effective_end_date, lp_Tax_Year_End_Date) >= lp_Tax_Year_Start_Date

Line 607: FROM per_all_assignments_f asg, per_assignment_status_types past

603:
604: BEGIN
605:
606: SELECT 1 INTO l_active_asg_flag
607: FROM per_all_assignments_f asg, per_assignment_status_types past
608: WHERE asg.assignment_id = l_assignment_id
609: and past.assignment_status_type_id = asg.assignment_status_type_id
610: and past.per_system_status = 'ACTIVE_ASSIGN'
611: and asg.effective_start_date <= l_Tax_Year_End_Date

Line 2837: from per_all_assignments_f paa,hr_soft_coding_keyflex sck

2833:
2834:
2835: cursor csr_get_income_code is
2836: select sck.segment8,SUM(decode(sign(p_tax_year_end_date - paa.effective_end_date),-1,p_tax_year_end_date,paa.effective_end_date)-decode(sign(paa.effective_start_date - p_tax_year_start_date),-1,p_tax_year_start_date,paa.effective_start_date)+1) Days
2837: from per_all_assignments_f paa,hr_soft_coding_keyflex sck
2838: where paa.assignment_id = p_assignment_id
2839: and (paa.effective_start_date >= p_tax_year_start_date or p_tax_year_start_date between paa.effective_start_date and paa.effective_end_date)
2840: and (paa.effective_end_date <= p_tax_year_end_date or paa.effective_start_date <= p_tax_year_end_date)
2841: and sck.soft_coding_keyflex_id=paa.soft_coding_keyflex_id