APPS.PSP_ENC_SUM_TRAN dependencies on GMS_AWARDS_ALL

Line 6061: l_award_number gms_awards_all.award_number%TYPE;

6057: l_return_status VARCHAR2(1);
6058: l_cnt_gms_interface NUMBER;
6059: l_project_number pa_projects_all.segment1%TYPE;
6060: l_task_number VARCHAR2(300); -- pa_tasks.task_number%TYPE; -- Bug 16391366 (27/03/2013)
6061: l_award_number gms_awards_all.award_number%TYPE;
6062: l_exp_org_name hr_organization_units.name%TYPE;
6063: l_gl_description VARCHAR2(4000);
6064:
6065: CURSOR project_number_cur IS

Line 6072: FROM gms_awards_all

6068: WHERE project_id = l_project_id;
6069:
6070: CURSOR award_number_cur IS
6071: SELECT award_number
6072: FROM gms_awards_all
6073: WHERE award_id = l_award_id;
6074:
6075: CURSOR task_number_cur Is
6076: SELECT task_number

Line 7092: l_award_number gms_awards_all.award_number%TYPE;

7088: l_organization_name hr_organization_units.name%TYPE;
7089: l_element_name pay_element_types_f.element_name%TYPE;
7090: l_project_number pa_projects_all.segment1%TYPE;
7091: l_task_number VARCHAR2(300); -- pa_tasks.task_number%TYPE; -- Bug 16391366 (27/03/2013)
7092: l_award_number gms_awards_all.award_number%TYPE;
7093: l_exp_org_name hr_organization_units.name%TYPE;
7094: l_gl_description VARCHAR2(4000);
7095: l_return_status VARCHAR2(1);
7096:

Line 7135: FROM gms_awards_all

7131: WHERE project_id = p_project_id;
7132:
7133: CURSOR award_number_cur (p_award_id IN NUMBER) IS
7134: SELECT award_number
7135: FROM gms_awards_all
7136: WHERE award_id = p_award_id;
7137:
7138: CURSOR task_number_cur (p_task_id IN NUMBER) IS
7139: SELECT task_number