APPS.PSP_ENC_SUM_TRAN dependencies on GMS_AWARDS_ALL

Line 5878: l_award_number gms_awards_all.award_number%TYPE;

5874: l_return_status VARCHAR2(1);
5875: l_cnt_gms_interface NUMBER;
5876: l_project_number pa_projects_all.segment1%TYPE;
5877: l_task_number pa_tasks.task_number%TYPE;
5878: l_award_number gms_awards_all.award_number%TYPE;
5879: l_exp_org_name hr_organization_units.name%TYPE;
5880: l_gl_description VARCHAR2(4000);
5881:
5882: CURSOR project_number_cur IS

Line 5889: FROM gms_awards_all

5885: WHERE project_id = l_project_id;
5886:
5887: CURSOR award_number_cur IS
5888: SELECT award_number
5889: FROM gms_awards_all
5890: WHERE award_id = l_award_id;
5891:
5892: CURSOR task_number_cur Is
5893: SELECT task_number

Line 6856: l_award_number gms_awards_all.award_number%TYPE;

6852: l_organization_name hr_organization_units.name%TYPE;
6853: l_element_name pay_element_types_f.element_name%TYPE;
6854: l_project_number pa_projects_all.segment1%TYPE;
6855: l_task_number pa_tasks.task_number%TYPE;
6856: l_award_number gms_awards_all.award_number%TYPE;
6857: l_exp_org_name hr_organization_units.name%TYPE;
6858: l_gl_description VARCHAR2(4000);
6859: l_return_status VARCHAR2(1);
6860:

Line 6899: FROM gms_awards_all

6895: WHERE project_id = p_project_id;
6896:
6897: CURSOR award_number_cur (p_award_id IN NUMBER) IS
6898: SELECT award_number
6899: FROM gms_awards_all
6900: WHERE award_id = p_award_id;
6901:
6902: CURSOR task_number_cur (p_task_id IN NUMBER) IS
6903: SELECT task_number