APPS.PSP_ENC_CREATE_LINES dependencies on PA_PROJECTS_ALL

Line 1410: l_project_number pa_projects_all.segment1%TYPE;

1406: FROM per_all_assignments_f paf
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);

Line 1504: FROM pa_projects_all

1500: WHERE organization_id = l_organization_id;
1501:
1502: CURSOR project_number_cur IS
1503: SELECT SEGMENT1
1504: FROM pa_projects_all
1505: WHERE project_id = l_project_id;
1506:
1507: CURSOR award_number_cur IS
1508: SELECT award_number

Line 6790: FROM pa_projects_all

6786:
6787: PROCEDURE log_cel_warnings IS
6788: CURSOR project_number_cur (p_project_id IN NUMBER) IS
6789: SELECT SEGMENT1
6790: FROM pa_projects_all
6791: WHERE project_id = p_project_id;
6792:
6793: CURSOR award_number_cur (p_award_id IN NUMBER) IS
6794: SELECT award_number

Line 6808: l_project_number pa_projects_all.segment1%TYPE;

6804: SELECT name
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);

Line 8281: pa_projects_all pa

8277: DECODE(g_dff_grouping_option, 'Y', pel.attribute10, NULL) attribute10,
8278: pa.org_id
8279: FROM PSP_ENC_LINES pel,
8280: PSP_ORGANIZATION_ACCOUNTS pos,
8281: pa_projects_all pa
8282: WHERE pel.ENCUMBRANCE_AMOUNT <> 0
8283: AND pel.assignment_id = p_assignment_id
8284: AND pel.payroll_id = p_payroll_id
8285: AND pel.suspense_org_account_id = pos.organization_account_id(+)