DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_GEN_ASSET_LINES dependencies on PA_TASKS

Line 104: pa_tasks pt,

100: portion of the code needs to be un commented if CRL is installed */
101: IF (PA_INSTALL.is_product_installed('IPA')) AND (l_crl_rec IS NOT NULL) THEN
102: Select 1 into dummy
103: from pa_project_types ppt,
104: pa_tasks pt,
105: pa_tasks pt2,
106: pa_projects_all ppr -- Changed to _ALL as part of MOAC changes
107: where p_task_id = pt.task_id and
108: p_project_id = pt.project_id and

Line 105: pa_tasks pt2,

101: IF (PA_INSTALL.is_product_installed('IPA')) AND (l_crl_rec IS NOT NULL) THEN
102: Select 1 into dummy
103: from pa_project_types ppt,
104: pa_tasks pt,
105: pa_tasks pt2,
106: pa_projects_all ppr -- Changed to _ALL as part of MOAC changes
107: where p_task_id = pt.task_id and
108: p_project_id = pt.project_id and
109: pt.project_id = ppr.project_id and