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 1528: l_project_id1 IN pa_projects_all.project_id%TYPE, -- Original Encumbrance Project Id

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

Line 1542: from pa_projects_all

1538: from pa_tasks tsk1
1539: where task_id = l_task_id1
1540: union all
1541: select start_date, completion_date
1542: from pa_projects_all
1543: where project_id = l_project_id1
1544: union all
1545: select start_date_active start_date, end_date_active completion_date
1546: from gms_awards_all