[Home] [Help]
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,
41: hr_organization_information hoi1,
42: hr_all_organization_units_tl bptl,
43: hr_organization_units bp
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
46: and bptl.language = userenv('LANG')
47: and hoi1.organization_id = bp.organization_id
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
74: where bp1.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID') --Bug 5069923
75: and hoi1.organization_id = bp1.organization_id
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'
77: and bp2.business_group_id = bp1.business_group_id
138: per_periods_of_service pds,
139: per_assignments_f pa,
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