DBA Data[Home] [Help]

APPS.PAY_MX_PAYREG_PKG dependencies on PER_MX_GRES_LEGAL_EMPLOYER_V

Line 212: FROM per_mx_gres_legal_employer_v

208: AND paf.assignment_id = act.assignment_id
209: AND (c_tax_unit_id IS NULL
210: OR act.tax_unit_id = c_tax_unit_id)
211: AND act.tax_unit_id IN (SELECT tax_unit_id
212: FROM per_mx_gres_legal_employer_v
213: WHERE legal_employer_id = c_legal_emp_id)
214: AND (c_organization_id IS NULL
215: OR paf.organization_id = c_organization_id)
216: AND (c_person_id IS NULL

Line 269: FROM per_mx_gres_legal_employer_v

265: AND paf.assignment_id = act.assignment_id
266: AND (c_tax_unit_id IS NULL
267: OR act.tax_unit_id = c_tax_unit_id)
268: AND act.tax_unit_id IN (SELECT tax_unit_id
269: FROM per_mx_gres_legal_employer_v
270: WHERE legal_employer_id = c_legal_emp_id)
271: AND (c_organization_id IS NULL
272: OR paf.organization_id = c_organization_id)
273: AND (c_person_id IS NULL