APPS.GMS_LD_PKG dependencies on GMS_AWARDS_ALL

Line 241: l_award_id gms_awards_all.award_id%TYPE; /*Bug# 4138033*/

237: l_rowid VARCHAR2(40);
238: l_person_id NUMBER(15);
239: l_task_number VARCHAR2(40);
240: l_project_id NUMBER(15);
241: l_award_id gms_awards_all.award_id%TYPE; /*Bug# 4138033*/
242: l_enc_item_id NUMBER(15);
243: l_project_number VARCHAR2(25);
244: x_calling_module varchar2(50) ;
245: x_acct_currency_code VARCHAR2(15); -- Added for Bug:1331903

Line 369: gms_awards_all ga

365:
366: CURSOR C1 IS
367: SELECT ga.award_id
368: FROM gms_transaction_interface_all gtxn,
369: gms_awards_all ga
370: WHERE ((gtxn.award_number IS NULL AND ga.award_id = NVL(gtxn.award_id,0) ) OR
371: (ga.award_number = gtxn.award_number) )
372: AND gtxn.txn_interface_id = Trxrec.txn_interface_id ;
373:

Line 1530: ( l_award_id1 IN gms_awards_all.award_id%TYPE, -- Original Encumbrance Award Id

1526: END;
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

Line 1558: from gms_awards_all

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
1559: where award_id = l_award_id1
1560: );
1561:
1562: l_max_start_date DATE;