DBA Data[Home] [Help]

APPS.WMS_ASSIGNMENT_PVT dependencies on PA_PROJECTS_ALL

Line 96: FROM pa_projects_all ppa

92: ;
93: --
94: CURSOR obj13 IS -- source project
95: SELECT ppa.segment1
96: FROM pa_projects_all ppa
97: WHERE ppa.project_id = fnd_number.canonical_to_number(p_pk1_value)
98: ;
99: --
100: CURSOR obj14 IS -- source task

Line 102: FROM pa_projects_all ppa

98: ;
99: --
100: CURSOR obj14 IS -- source task
101: SELECT ppa.segment1||' / '||pt.task_number
102: FROM pa_projects_all ppa
103: ,pa_tasks pt
104: where pt.task_id = fnd_number.canonical_to_number(p_pk1_value)
105: and ppa.project_id = pt.project_id
106: ;