DBA Data[Home] [Help]

APPS.CSE_DEPLOYMENT_GRP dependencies on PA_PROJECTS_ALL

Line 725: FROM pa_projects_all

721: debug(' item : '||l_item_name);
722:
723: SELECT segment1
724: INTO l_project_number
725: FROM pa_projects_all
726: WHERE project_id = p_trf_pa_attr_rec.to_project_id;
727:
728: SELECT task_number
729: INTO l_task_number

Line 894: FROM pa_projects_all

890: FROM sys.dual;
891:
892: SELECT segment1
893: INTO l_nl_pa_interface_tbl(i).project_number
894: FROM pa_projects_all
895: WHERE project_id = p_trf_pa_attr_rec.project_id;
896:
897: SELECT task_number
898: INTO l_nl_pa_interface_tbl(i).task_number

Line 921: FROM pa_projects_all

917: -- but found in pa_transaction_interface_all
918: BEGIN
919: SELECT segment1
920: INTO l_from_project_number
921: FROM pa_projects_all
922: WHERE project_id = p_trf_pa_attr_rec.project_id;
923: EXCEPTION
924: WHEN NO_DATA_FOUND THEN
925: NULL;

Line 1035: FROM pa_projects_all

1031: FROM sys.dual;
1032:
1033: SELECT segment1
1034: INTO l_nl_pa_interface_tbl(i).project_number
1035: FROM pa_projects_all
1036: WHERE project_id = p_trf_pa_attr_rec.to_project_id;
1037:
1038: SELECT task_number
1039: INTO l_nl_pa_interface_tbl(i).task_number