DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_GEN_ASSET_LINES dependencies on PA_TASKS

Line 74: pa_tasks pt,

70: portion of the code needs to be un commented if CRL is installed */
71: IF (PA_INSTALL.is_product_installed('IPA')) AND (l_crl_rec IS NOT NULL) THEN
72: Select 1 into dummy
73: from pa_project_types ppt,
74: pa_tasks pt,
75: pa_tasks pt2,
76: pa_projects_all ppr -- Changed to _ALL as part of MOAC changes
77: where p_task_id = pt.task_id and
78: p_project_id = pt.project_id and

Line 75: pa_tasks pt2,

71: IF (PA_INSTALL.is_product_installed('IPA')) AND (l_crl_rec IS NOT NULL) THEN
72: Select 1 into dummy
73: from pa_project_types ppt,
74: pa_tasks pt,
75: pa_tasks pt2,
76: pa_projects_all ppr -- Changed to _ALL as part of MOAC changes
77: where p_task_id = pt.task_id and
78: p_project_id = pt.project_id and
79: pt.project_id = ppr.project_id and