APPS.PSP_ENC_CREATE_LINES dependencies on PA_PROJECTS_ALL

Line 1625: l_project_number pa_projects_all.segment1%TYPE;

1621: FROM per_all_assignments_f paf
1622: WHERE paf.assignment_id =p_assignment_id
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);

Line 1719: FROM pa_projects_all

1715: WHERE organization_id = l_organization_id;
1716:
1717: CURSOR project_number_cur IS
1718: SELECT SEGMENT1
1719: FROM pa_projects_all
1720: WHERE project_id = l_project_id;
1721:
1722: CURSOR award_number_cur IS
1723: SELECT award_number

Line 7067: FROM pa_projects_all

7063:
7064: PROCEDURE log_cel_warnings IS
7065: CURSOR project_number_cur (p_project_id IN NUMBER) IS
7066: SELECT SEGMENT1
7067: FROM pa_projects_all
7068: WHERE project_id = p_project_id;
7069:
7070: CURSOR award_number_cur (p_award_id IN NUMBER) IS
7071: SELECT award_number

Line 7085: l_project_number pa_projects_all.segment1%TYPE;

7081: SELECT name
7082: FROM hr_organization_units
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);

Line 8603: pa_projects_all pa

8599: DECODE(g_dff_grouping_option, 'Y', pel.attribute10, NULL) attribute10,
8600: pa.org_id
8601: FROM PSP_ENC_LINES pel,
8602: PSP_ORGANIZATION_ACCOUNTS pos,
8603: pa_projects_all pa
8604: WHERE pel.ENCUMBRANCE_AMOUNT <> 0
8605: AND pel.assignment_id = p_assignment_id
8606: AND pel.payroll_id = p_payroll_id
8607: AND pel.suspense_org_account_id = pos.organization_account_id(+)