DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 41: hr_organization_units corp,

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,
43: hr_organization_information hoi1,
44: hr_all_organization_units_tl bptl,
45: hr_organization_units bp

Line 45: hr_organization_units bp

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
48: and bptl.language = userenv('LANG')
49: and hoi1.organization_id = bp.organization_id

Line 74: hr_organization_units bp2,

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
77: where bp1.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID') --Bug 5069923
78: and hoi1.organization_id = bp1.organization_id

Line 76: hr_organization_units bp1

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'
80: and bp2.business_group_id = bp1.business_group_id

Line 149: hr_organization_units bp,

145: per_periods_of_service pds,
146: per_assignments_f pa,
147: pay_assignment_actions paa,
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,