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 38: from hr_organization_information hoi3,

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

Line 42: hr_organization_information hoi2,

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

Line 43: hr_organization_information hoi1,

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

Line 71: from hr_organization_information hoi3,

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

Line 72: hr_organization_information hoi2,

68: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
69: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS'),
70: 'REP_PERIOD_CODE=P', g_rep_period_code
71: from hr_organization_information hoi3,
72: hr_organization_information hoi2,
73: hr_all_organization_units_tl bptl2,
74: hr_organization_units bp2,
75: hr_organization_information hoi1,
76: hr_organization_units bp1

Line 75: hr_organization_information hoi1,

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

Line 87: from hr_organization_information

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

Line 152: hr_organization_information hoi1,

148: pay_payroll_actions ppa,
149: hr_organization_units bp,
150: fnd_territories ft,
151: per_addresses adr,
152: hr_organization_information hoi1,
153: hr_organization_information hoi2,
154: hr_organization_information hoi3
155: where hoi1.org_information2 = p_bp_number --Bug2822459
156: and hoi2.org_information9 = p_tax_office_code --Bug2822459

Line 153: hr_organization_information hoi2,

149: hr_organization_units bp,
150: fnd_territories ft,
151: per_addresses adr,
152: hr_organization_information hoi1,
153: hr_organization_information hoi2,
154: hr_organization_information hoi3
155: where hoi1.org_information2 = p_bp_number --Bug2822459
156: and hoi2.org_information9 = p_tax_office_code --Bug2822459
157: and hoi1.organization_id = bp.organization_id

Line 154: hr_organization_information hoi3

150: fnd_territories ft,
151: per_addresses adr,
152: hr_organization_information hoi1,
153: hr_organization_information hoi2,
154: hr_organization_information hoi3
155: where hoi1.org_information2 = p_bp_number --Bug2822459
156: and hoi2.org_information9 = p_tax_office_code --Bug2822459
157: and hoi1.organization_id = bp.organization_id
158: and hoi1.organization_id = hoi2.organization_id