DBA Data[Home] [Help]

APPS.GMS_LD_PKG dependencies on PA_TASKS

Line 736: from pa_tasks

732: ----------------------------------------------------------------------------
733: if ((TASK_FIRST) OR (l_project_number <> TrxRec.project_number) OR (l_task_number <> TrxRec.task_number)) then
734: select task_id
735: into l_task_id
736: from pa_tasks
737: where task_number = TrxRec.task_number
738: and project_id = l_project_id;
739:
740: TASK_FIRST := FALSE;

Line 1532: l_task_id1 IN pa_tasks.task_id%TYPE, -- Original Encumbrance Task Id

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:
1536: /* relaxing this check from bug 7271321

Line 1550: from pa_tasks tsk1

1546: -- out of award, project and task's start and end dates.
1547: CURSOR Cur_MaxMin_StartEnd_Dates IS
1548: SELECT max(start_date), min(completion_date)
1549: FROM ( select start_date, completion_date
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