APPS.PSP_ENC_CREATE_LINES dependencies on PA_TASKS

Line 1411: l_task_number pa_tasks.task_number%TYPE;

1407: WHERE paf.assignment_id =p_assignment_id
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;

Line 1514: FROM pa_tasks

1510: WHERE award_id = l_award_id;
1511:
1512: CURSOR task_number_cur Is
1513: SELECT task_number
1514: FROM pa_tasks
1515: WHERE task_id = l_task_id;
1516:
1517: CURSOR exp_org_name_cur IS
1518: SELECT name

Line 6800: FROM pa_tasks

6796: WHERE award_id = p_award_id;
6797:
6798: CURSOR task_number_cur (p_task_id IN NUMBER) IS
6799: SELECT task_number
6800: FROM pa_tasks
6801: WHERE task_id = p_task_id;
6802:
6803: CURSOR exp_org_name_cur (p_expenditure_org_id IN NUMBER) IS
6804: SELECT name

Line 6809: l_task_number pa_tasks.task_number%TYPE;

6805: FROM hr_organization_units
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