DBA Data[Home] [Help]

APPS.PAY_KR_YEA_DON_EFILE_CONC_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 113: hr_organization_information hoi1,

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
117: and hoi2.org_information9 = p_tax_office_code

Line 114: hr_organization_information hoi2,

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
117: and hoi2.org_information9 = p_tax_office_code
118: and hoi1.organization_id = bp.organization_id

Line 173: hr_organization_information hoi1,

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,
177: per_kr_resident_reg_number_v resreg

Line 174: hr_organization_information hoi2,

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,
177: per_kr_resident_reg_number_v resreg
178: where hoi1.org_information2 = p_bp_number