APPS.JA_CN_ITEMIZATION_INTERFACE dependencies on PA_PROJECTS_ALL

Line 387: from PA_PROJECTS_ALL

383: end if;
384: if l_PROJECT_SOURCE='PA' and l_PROJECT_NUMBER is not null then
385: select count(*)
386: into l_count
387: from PA_PROJECTS_ALL
388: where SEGMENT1=l_PROJECT_NUMBER;
389: if l_count=0 then
390: update ja_cn_item_interface
391: set status='EPN1'

Line 2427: from PA_PROJECTS_ALL

2423: exit when c_project%notfound;
2424: if l_project_source='PA' then
2425: select project_id
2426: into l_project_id
2427: from PA_PROJECTS_ALL
2428: where SEGMENT1=l_PROJECT_NUMBER;
2429: elsif l_project_source='COA'then
2430: select flex_value_id
2431: into l_project_id