APPS.PSP_ENC_CREATE_LINES dependencies on GMS_AWARDS_ALL

Line 1412: l_award_number gms_awards_all.award_number%TYPE;

1408: AND ROWNUM=1;
1409:
1410: l_project_number pa_projects_all.segment1%TYPE;
1411: l_task_number pa_tasks.task_number%TYPE;
1412: l_award_number gms_awards_all.award_number%TYPE;
1413: l_exp_org_name hr_organization_units.name%TYPE;
1414: l_gl_description VARCHAR2(4000);
1415: l_time_period_id NUMBER;
1416: l_return_status VARCHAR2(1);

Line 1509: FROM gms_awards_all

1505: WHERE project_id = l_project_id;
1506:
1507: CURSOR award_number_cur IS
1508: SELECT award_number
1509: FROM gms_awards_all
1510: WHERE award_id = l_award_id;
1511:
1512: CURSOR task_number_cur Is
1513: SELECT task_number

Line 6795: FROM gms_awards_all

6791: WHERE project_id = p_project_id;
6792:
6793: CURSOR award_number_cur (p_award_id IN NUMBER) IS
6794: SELECT award_number
6795: FROM gms_awards_all
6796: WHERE award_id = p_award_id;
6797:
6798: CURSOR task_number_cur (p_task_id IN NUMBER) IS
6799: SELECT task_number

Line 6810: l_award_number gms_awards_all.award_number%TYPE;

6806: WHERE organization_id = p_expenditure_org_id;
6807:
6808: l_project_number pa_projects_all.segment1%TYPE;
6809: l_task_number pa_tasks.task_number%TYPE;
6810: l_award_number gms_awards_all.award_number%TYPE;
6811: l_exp_org_name hr_organization_units.name%TYPE;
6812: l_gl_description VARCHAR2(1000);
6813: BEGIN
6814: FOR recno IN 1..cel_warnings.start_date.COUNT