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_TAX_VAL dependencies on PAY_ALL_PAYROLLS_F

Line 34: pay_all_payrolls_f pay,

30: ,per.NATIONAL_IDENTIFIER pps_number
31: ,count(distinct(asg.ASSIGNMENT_NUMBER)) no_of_assg
32: from per_all_assignments_f asg,
33: per_all_people_f per,
34: pay_all_payrolls_f pay,
35: pay_ie_tax_body_interface tbi,
36: per_periods_of_service pps
37: where per.national_identifier = tbi.pps_number
38: --AND pay.payroll_id = nvl(p_payroll_id,pay.payroll_id)

Line 138: , pay_all_payrolls_f pay

134: FROM hr_organization_information hoi
135: , hr_organization_units hou
136: , per_all_assignments_f asg
137: , per_all_people_f per
138: , pay_all_payrolls_f pay
139: --, pay_ie_paye_details_f ppd
140: , pay_ie_tax_body_interface tbi
141: , pay_ie_tax_header_interface thi
142: WHERE per.person_id = asg.person_id

Line 240: , pay_all_payrolls_f pay

236: FROM hr_organization_information hoi
237: , hr_organization_units hou
238: , per_all_assignments_f asg
239: , per_all_people_f per
240: , pay_all_payrolls_f pay
241: --, pay_ie_paye_details_f ppd
242: , pay_ie_tax_body_interface tbi
243: , pay_ie_tax_header_interface thi,
244: per_periods_of_service pps

Line 284: , pay_all_payrolls_f pay

280: FROM hr_organization_information hoi
281: , hr_organization_units hou
282: , per_all_assignments_f asg
283: , per_all_people_f per
284: , pay_all_payrolls_f pay
285: --, pay_ie_paye_details_f ppd
286: , pay_ie_tax_body_interface tbi
287: , pay_ie_tax_header_interface thi
288: WHERE per.person_id = asg.person_id

Line 3259: pay_all_payrolls_f pay,

3255: ,per.NATIONAL_IDENTIFIER pps_number
3256: ,count(distinct(asg.ASSIGNMENT_NUMBER)) no_of_assg
3257: from per_all_assignments_f asg,
3258: per_all_people_f per,
3259: pay_all_payrolls_f pay,
3260: pay_ie_tax_body_interface tbi,
3261: per_periods_of_service pps
3262: where per.national_identifier = tbi.pps_number
3263: --AND pay.payroll_id = nvl(p_payroll_id,pay.payroll_id)

Line 3327: , pay_all_payrolls_f pay

3323: FROM hr_organization_information hoi
3324: , hr_organization_units hou
3325: , per_all_assignments_f asg
3326: , per_all_people_f per
3327: , pay_all_payrolls_f pay
3328: --, pay_ie_paye_details_f ppd
3329: , pay_ie_tax_body_interface tbi
3330: , pay_ie_tax_header_interface thi
3331: WHERE per.person_id = asg.person_id

Line 3393: , pay_all_payrolls_f pay

3389: FROM hr_organization_information hoi
3390: , hr_organization_units hou
3391: , per_all_assignments_f asg
3392: , per_all_people_f per
3393: , pay_all_payrolls_f pay
3394: --, pay_ie_paye_details_f ppd
3395: , pay_ie_tax_body_interface tbi
3396: , pay_ie_tax_header_interface thi,
3397: per_periods_of_service pps

Line 3437: , pay_all_payrolls_f pay

3433: FROM hr_organization_information hoi
3434: , hr_organization_units hou
3435: , per_all_assignments_f asg
3436: , per_all_people_f per
3437: , pay_all_payrolls_f pay
3438: --, pay_ie_paye_details_f ppd
3439: , pay_ie_tax_body_interface tbi
3440: , pay_ie_tax_header_interface thi
3441: WHERE per.person_id = asg.person_id