APPS.GMS_CLIENT_EXTN_BUDGET_WF dependencies on PA_BUDGET_TYPES

Line 299: FROM pa_budget_types

295: --
296: CURSOR l_budget_type_csr( p_budget_type_code VARCHAR2 )
297: IS
298: SELECT budget_type
299: FROM pa_budget_types
300: WHERE budget_type_code = p_budget_type_code;
301:
302: CURSOR l_wf_notification_role_csr(p_award_id NUMBER)
303: IS

Line 348: l_budget_type pa_budget_types.budget_type%TYPE;

344: l_total_revenue NUMBER;
345: l_resource_list_id NUMBER;
346: l_resource_list_name pa_resource_lists.name%TYPE;
347: l_resource_list_description pa_resource_lists.description%TYPE;
348: l_budget_type pa_budget_types.budget_type%TYPE;
349: l_wf_started_date DATE;
350:
351: l_workflow_started_by_id NUMBER;
352: l_starter_name VARCHAR2(240);

Line 1037: FROM pa_budget_types

1033: --
1034: CURSOR l_budget_type_csr( p_budget_type_code VARCHAR2 )
1035: IS
1036: SELECT budget_type
1037: FROM pa_budget_types
1038: WHERE budget_type_code = p_budget_type_code;
1039:
1040: CURSOR l_wf_notification_role_csr(p_award_id NUMBER)
1041: IS

Line 1086: l_budget_type pa_budget_types.budget_type%TYPE;

1082: l_total_revenue NUMBER;
1083: l_resource_list_id NUMBER;
1084: l_resource_list_name pa_resource_lists.name%TYPE;
1085: l_resource_list_description pa_resource_lists.description%TYPE;
1086: l_budget_type pa_budget_types.budget_type%TYPE;
1087: l_wf_started_date DATE;
1088:
1089: l_workflow_started_by_id NUMBER;
1090: l_starter_name VARCHAR2(240);