DBA Data[Home] [Help]

APPS.PAY_KR_YEA_DON_EFILE_CONC_PKG dependencies on HR_ORGANIZATION_UNITS

Line 82: from hr_organization_units hou

78: is
79:
80: cursor csr_business_group_id is
81: select hou.business_group_id
82: from hr_organization_units hou
83: where hou.organization_id = p_business_place ;
84: begin
85: open csr_business_group_id ;
86: fetch csr_business_group_id into p_business_group_id ;

Line 112: hr_organization_units bp,

108: from per_people_f pp,
109: per_assignments_f pa,
110: pay_assignment_actions paa,
111: pay_payroll_actions ppa,
112: hr_organization_units bp,
113: hr_organization_information hoi1,
114: hr_organization_information hoi2,
115: per_assignment_extra_info pae
116: where hoi1.org_information2 = p_bp_number

Line 172: hr_organization_units bp,

168: from
169: per_assignment_extra_info aei,
170: pay_assignment_actions paa,
171: pay_payroll_actions ppa,
172: hr_organization_units bp,
173: hr_organization_information hoi1,
174: hr_organization_information hoi2,
175: per_people_f pp,
176: per_assignments_f pa,