DBA Data[Home] [Help]

APPS.PAY_KR_YEA_DON_EFILE_CONC_PKG dependencies on PER_PEOPLE_F

Line 108: from per_people_f pp,

104: select
105: count(*),
106: sum(nvl(to_number(aei_information9),0)),
107: sum(nvl(to_number(aei_information10),0))
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,

Line 175: per_people_f pp,

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