DBA Data[Home] [Help]

APPS.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on PA_PROJECTS

Line 116: -- FROM fnd_lookups l, pa_projects p bug#4574838

112: c_trx_date DATE,
113: c_org_id NUMBER) IS
114: SELECT p.output_tax_code,
115: p.retention_tax_code
116: -- FROM fnd_lookups l, pa_projects p bug#4574838
117: FROM zx_output_classifications_v l,
118: pa_projects p
119: WHERE p.project_id = c_project_id
120: AND l.lookup_code = decode(c_retention_flag,'TRUE',p.retention_tax_code,p.output_tax_code)

Line 118: pa_projects p

114: SELECT p.output_tax_code,
115: p.retention_tax_code
116: -- FROM fnd_lookups l, pa_projects p bug#4574838
117: FROM zx_output_classifications_v l,
118: pa_projects p
119: WHERE p.project_id = c_project_id
120: AND l.lookup_code = decode(c_retention_flag,'TRUE',p.retention_tax_code,p.output_tax_code)
121: AND l.org_id IN (c_org_id, -99)
122: AND l.enabled_flag = 'Y'