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_KR_YEA_MAGTAPE_FUN_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 33: hr_organization_information hoi1,

29: select count(*)
30: from pay_assignment_actions paa,
31: pay_payroll_actions ppa,
32: hr_organization_units bp,
33: hr_organization_information hoi1,
34: hr_organization_information hoi2
35: where hoi1.org_information2 = p_bp_number --Bug# 2822459
36: and hoi2.org_information9 = p_tax_office_code
37: and hoi1.organization_id = hoi2.organization_id

Line 34: hr_organization_information hoi2

30: from pay_assignment_actions paa,
31: pay_payroll_actions ppa,
32: hr_organization_units bp,
33: hr_organization_information hoi1,
34: hr_organization_information hoi2
35: where hoi1.org_information2 = p_bp_number --Bug# 2822459
36: and hoi2.org_information9 = p_tax_office_code
37: and hoi1.organization_id = hoi2.organization_id
38: and hoi1.organization_id = bp.organization_id

Line 63: hr_organization_information hoi1,

59: from ff_archive_items i1,
60: pay_assignment_actions paa,
61: pay_payroll_actions ppa,
62: hr_organization_units bp,
63: hr_organization_information hoi1,
64: hr_organization_information hoi2
65: where hoi1.org_information2 = p_bp_number --Bug# 2822459
66: and hoi2.org_information9 = p_tax_office_code
67: and hoi1.organization_id = hoi2.organization_id

Line 64: hr_organization_information hoi2

60: pay_assignment_actions paa,
61: pay_payroll_actions ppa,
62: hr_organization_units bp,
63: hr_organization_information hoi1,
64: hr_organization_information hoi2
65: where hoi1.org_information2 = p_bp_number --Bug# 2822459
66: and hoi2.org_information9 = p_tax_office_code
67: and hoi1.organization_id = hoi2.organization_id
68: and hoi1.organization_id = bp.organization_id

Line 96: hr_organization_information hoi1,

92: from per_assignment_extra_info aei,
93: pay_assignment_actions paa,
94: pay_payroll_actions ppa,
95: hr_organization_units bp,
96: hr_organization_information hoi1,
97: hr_organization_information hoi2
98: where hoi1.org_information2 = p_bp_number --Bug# 2822459
99: and hoi2.org_information9 = p_tax_office_code
100: and hoi1.organization_id = hoi2.organization_id

Line 97: hr_organization_information hoi2

93: pay_assignment_actions paa,
94: pay_payroll_actions ppa,
95: hr_organization_units bp,
96: hr_organization_information hoi1,
97: hr_organization_information hoi2
98: where hoi1.org_information2 = p_bp_number --Bug# 2822459
99: and hoi2.org_information9 = p_tax_office_code
100: and hoi1.organization_id = hoi2.organization_id
101: and hoi1.organization_id = bp.organization_id