DBA Data[Home] [Help]

APPS.GMS_LD_PKG dependencies on PA_PROJECTS_ALL

Line 722: from pa_projects_all

718:
719: if ((PROJ_FIRST) OR (l_project_number <> TrxRec.project_number)) then
720: select project_id
721: into l_project_id
722: from pa_projects_all
723: where segment1 = TrxRec.project_number;
724:
725: PROJ_FIRST := FALSE;
726: end if;

Line 1531: l_project_id1 IN pa_projects_all.project_id%TYPE, -- Original Encumbrance Project Id

1527:
1528: /* Bug# 4138033 */
1529: PROCEDURE Validate_Dates_YN
1530: ( l_award_id1 IN gms_awards_all.award_id%TYPE, -- Original Encumbrance Award Id
1531: l_project_id1 IN pa_projects_all.project_id%TYPE, -- Original Encumbrance Project Id
1532: l_task_id1 IN pa_tasks.task_id%TYPE, -- Original Encumbrance Task Id
1533: l_orig_enc_item_id1 IN gms_encumbrance_items_all.encumbrance_item_id%TYPE -- Original Encumbrance Item Id
1534: ) IS
1535:

Line 1554: from pa_projects_all

1550: from pa_tasks tsk1
1551: where task_id = l_task_id1
1552: union all
1553: select start_date, completion_date
1554: from pa_projects_all
1555: where project_id = l_project_id1
1556: union all
1557: select start_date_active start_date, end_date_active completion_date
1558: from gms_awards_all