APPS.PSP_ENC_CREATE_LINES dependencies on GMS_AWARDS_ALL

Line 1627: l_award_number gms_awards_all.award_number%TYPE;

1623: AND ROWNUM=1;
1624:
1625: l_project_number pa_projects_all.segment1%TYPE;
1626: l_task_number VARCHAR2(300); -- pa_tasks.task_number%TYPE; Bug : 16391366 (27/03/2013)
1627: l_award_number gms_awards_all.award_number%TYPE;
1628: l_exp_org_name hr_organization_units.name%TYPE;
1629: l_gl_description VARCHAR2(4000);
1630: l_time_period_id NUMBER;
1631: l_return_status VARCHAR2(1);

Line 1724: FROM gms_awards_all

1720: WHERE project_id = l_project_id;
1721:
1722: CURSOR award_number_cur IS
1723: SELECT award_number
1724: FROM gms_awards_all
1725: WHERE award_id = l_award_id;
1726:
1727: CURSOR task_number_cur Is
1728: SELECT task_number

Line 7072: FROM gms_awards_all

7068: WHERE project_id = p_project_id;
7069:
7070: CURSOR award_number_cur (p_award_id IN NUMBER) IS
7071: SELECT award_number
7072: FROM gms_awards_all
7073: WHERE award_id = p_award_id;
7074:
7075: CURSOR task_number_cur (p_task_id IN NUMBER) IS
7076: SELECT task_number

Line 7087: l_award_number gms_awards_all.award_number%TYPE;

7083: WHERE organization_id = p_expenditure_org_id;
7084:
7085: l_project_number pa_projects_all.segment1%TYPE;
7086: l_task_number VARCHAR2(300); -- pa_tasks.task_number%TYPE; Bug : 16391366 (27/03/2013)
7087: l_award_number gms_awards_all.award_number%TYPE;
7088: l_exp_org_name hr_organization_units.name%TYPE;
7089: l_gl_description VARCHAR2(1000);
7090: BEGIN
7091: FOR recno IN 1..cel_warnings.start_date.COUNT