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

Line 36: from hr_organization_information hoi3,

32: 'CORP_REPR_NAME=P', hoi3.org_information6,
33: 'CORP_PHONE_NUMBER=P', loc.telephone_number_1,
34: 'B_RECORDS=P', to_char(g_b_records),
35: 'HOME_TAX_ID=P', nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')
36: from hr_organization_information hoi3,
37: hr_locations_all loc,
38: hr_all_organization_units_tl corptl,
39: hr_organization_units corp,
40: hr_organization_information hoi2,

Line 40: hr_organization_information hoi2,

36: from hr_organization_information hoi3,
37: hr_locations_all loc,
38: hr_all_organization_units_tl corptl,
39: hr_organization_units corp,
40: hr_organization_information hoi2,
41: hr_organization_information hoi1,
42: hr_all_organization_units_tl bptl,
43: hr_organization_units bp
44: where bp.organization_id = g_business_place_id

Line 41: hr_organization_information hoi1,

37: hr_locations_all loc,
38: hr_all_organization_units_tl corptl,
39: hr_organization_units corp,
40: hr_organization_information hoi2,
41: hr_organization_information hoi1,
42: hr_all_organization_units_tl bptl,
43: hr_organization_units bp
44: where bp.organization_id = g_business_place_id
45: and bptl.organization_id = bp.organization_id

Line 68: from hr_organization_information hoi3,

64: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),
65: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
66: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
67: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS')
68: from hr_organization_information hoi3,
69: hr_organization_information hoi2,
70: hr_all_organization_units_tl bptl2,
71: hr_organization_units bp2,
72: hr_organization_information hoi1,

Line 69: hr_organization_information hoi2,

65: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
66: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
67: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS')
68: from hr_organization_information hoi3,
69: hr_organization_information hoi2,
70: hr_all_organization_units_tl bptl2,
71: hr_organization_units bp2,
72: hr_organization_information hoi1,
73: hr_organization_units bp1

Line 72: hr_organization_information hoi1,

68: from hr_organization_information hoi3,
69: hr_organization_information hoi2,
70: hr_all_organization_units_tl bptl2,
71: hr_organization_units bp2,
72: hr_organization_information hoi1,
73: hr_organization_units bp1
74: where bp1.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID') --Bug 5069923
75: and hoi1.organization_id = bp1.organization_id
76: and hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'

Line 84: from hr_organization_information

80: or ( (hoi2.organization_id in ( select posev.ORGANIZATION_ID_child
81: from PER_ORG_STRUCTURE_ELEMENTS posev
82: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
83: and exists ( select null
84: from hr_organization_information
85: where organization_id = posev.ORGANIZATION_ID_child
86: and org_information_context = 'CLASS'
87: and org_information1 = 'KR_BUSINESS_PLACE'
88: )

Line 144: hr_organization_information hoi1,

140: pay_assignment_actions paa,
141: pay_payroll_actions ppa,
142: hr_organization_units bp,
143: fnd_territories ft,
144: hr_organization_information hoi1,
145: hr_organization_information hoi2
146: where hoi1.org_information2 = p_bp_number --Bug2822459
147: and hoi2.org_information9 = p_tax_office_code --Bug2822459
148: and hoi1.organization_id = bp.organization_id

Line 145: hr_organization_information hoi2

141: pay_payroll_actions ppa,
142: hr_organization_units bp,
143: fnd_territories ft,
144: hr_organization_information hoi1,
145: hr_organization_information hoi2
146: where hoi1.org_information2 = p_bp_number --Bug2822459
147: and hoi2.org_information9 = p_tax_office_code --Bug2822459
148: and hoi1.organization_id = bp.organization_id
149: and hoi1.organization_id = hoi2.organization_id