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

Line 25: from hr_organization_information hoi3,

21: 'PRIMARY_BP_NUMBER=P', hoi2.org_information2,
22: 'CORP_NAME=P', hoi3.org_information1,
23: 'B_RECORDS=P', to_char(g_b_records),
24: 'HOME_TAX_ID=P', nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')
25: from hr_organization_information hoi3,
26: hr_organization_units corp,
27: hr_organization_information hoi2,
28: hr_organization_information hoi1,
29: hr_all_organization_units_tl bptl,

Line 27: hr_organization_information hoi2,

23: 'B_RECORDS=P', to_char(g_b_records),
24: 'HOME_TAX_ID=P', nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')
25: from hr_organization_information hoi3,
26: hr_organization_units corp,
27: hr_organization_information hoi2,
28: hr_organization_information hoi1,
29: hr_all_organization_units_tl bptl,
30: hr_organization_units bp
31: where bp.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

Line 28: hr_organization_information hoi1,

24: 'HOME_TAX_ID=P', nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')
25: from hr_organization_information hoi3,
26: hr_organization_units corp,
27: hr_organization_information hoi2,
28: hr_organization_information hoi1,
29: hr_all_organization_units_tl bptl,
30: hr_organization_units bp
31: where bp.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
32: and bptl.organization_id = bp.organization_id

Line 52: from hr_organization_information hoi3,

48: 'D_RECORDS=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS'),
49: 'DON_AMT=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'DON_AMT'),
50: 'AMT_SUB_EXEM=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'AMT_SUB_EXEM'),
51: 'REP_PERIOD_CODE=P', g_rep_period_code
52: from hr_organization_information hoi3,
53: hr_organization_information hoi2,
54: hr_all_organization_units_tl bptl2,
55: hr_organization_units bp2,
56: hr_organization_information hoi1,

Line 53: hr_organization_information hoi2,

49: 'DON_AMT=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'DON_AMT'),
50: 'AMT_SUB_EXEM=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'AMT_SUB_EXEM'),
51: 'REP_PERIOD_CODE=P', g_rep_period_code
52: from hr_organization_information hoi3,
53: hr_organization_information hoi2,
54: hr_all_organization_units_tl bptl2,
55: hr_organization_units bp2,
56: hr_organization_information hoi1,
57: hr_organization_units bp1

Line 56: hr_organization_information hoi1,

52: from hr_organization_information hoi3,
53: hr_organization_information hoi2,
54: hr_all_organization_units_tl bptl2,
55: hr_organization_units bp2,
56: hr_organization_information hoi1,
57: hr_organization_units bp1
58: where bp1.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
59: and hoi1.organization_id = bp1.organization_id
60: and hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'

Line 67: from hr_organization_information

63: or ( (hoi2.organization_id in ( select posev.ORGANIZATION_ID_child
64: from PER_ORG_STRUCTURE_ELEMENTS posev
65: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
66: and exists ( select null
67: from hr_organization_information
68: where organization_id = posev.ORGANIZATION_ID_child
69: and org_information_context = 'CLASS'
70: and org_information1 = 'KR_BUSINESS_PLACE'
71: )

Line 117: hr_organization_information hoi1,

113: from per_assignments_f pa,
114: pay_assignment_actions paa,
115: pay_payroll_actions ppa,
116: hr_organization_units bp,
117: hr_organization_information hoi1,
118: hr_organization_information hoi2
119: where hoi1.org_information2 = p_bp_number
120: and hoi2.org_information9 = p_tax_office_code
121: and hoi1.organization_id = bp.organization_id

Line 118: hr_organization_information hoi2

114: pay_assignment_actions paa,
115: pay_payroll_actions ppa,
116: hr_organization_units bp,
117: hr_organization_information hoi1,
118: hr_organization_information hoi2
119: where hoi1.org_information2 = p_bp_number
120: and hoi2.org_information9 = p_tax_office_code
121: and hoi1.organization_id = bp.organization_id
122: and hoi1.organization_id = hoi2.organization_id