DBA Data[Home] [Help]

APPS.PAY_KR_YEA_DON_EFILE_CONC_PKG dependencies on PER_ASSIGNMENTS_F

Line 109: per_assignments_f pa,

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,
113: hr_organization_information hoi1,

Line 176: per_assignments_f pa,

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
180: and hoi1.organization_id = hoi2.organization_id