APPS.PA_FI_AMT_CALC_PKG dependencies on PA_EXPENDITURE_TYPES

Line 454: l_prev_exp_type Pa_Expenditure_Types.EXPENDITURE_TYPE%TYPE;

450:
451: l_prev_project_id NUMBER;
452: l_prev_asg_id NUMBER;
453: l_prev_proj_orgid NUMBER;
454: l_prev_exp_type Pa_Expenditure_Types.EXPENDITURE_TYPE%TYPE;
455: /* Project Info */
456: l_prj_type Pa_Projects_All.Project_Type%TYPE;
457: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
458: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;

Line 559: l_cc_sys_link Pa_Expenditure_Types.System_Linkage_Function%TYPE;

555: lx_cc_prvdr_orgid_tab PA_PLSQL_DATATYPES.IdTabTyp;
556: lx_cc_error_stage VARCHAR2(500);
557: lx_cc_error_code NUMBER;
558:
559: l_cc_sys_link Pa_Expenditure_Types.System_Linkage_Function%TYPE;
560: l_cc_exp_category Pa_Expenditure_Types.EXPENDITURE_CATEGORY%TYPE;
561:
562: l_tp_asgid PA_PLSQL_DATATYPES.IdTabTyp;
563: l_tp_exp_category PA_PLSQL_DATATYPES.Char30TabTyp;

Line 560: l_cc_exp_category Pa_Expenditure_Types.EXPENDITURE_CATEGORY%TYPE;

556: lx_cc_error_stage VARCHAR2(500);
557: lx_cc_error_code NUMBER;
558:
559: l_cc_sys_link Pa_Expenditure_Types.System_Linkage_Function%TYPE;
560: l_cc_exp_category Pa_Expenditure_Types.EXPENDITURE_CATEGORY%TYPE;
561:
562: l_tp_asgid PA_PLSQL_DATATYPES.IdTabTyp;
563: l_tp_exp_category PA_PLSQL_DATATYPES.Char30TabTyp;
564: l_tp_exp_itemid PA_PLSQL_DATATYPES.IdTabTyp;

Line 1807: FROM pa_expenditure_types WHERE

1803: l_prev_exp_type := l_fi_exptype_tab(i);
1804: BEGIN
1805: SELECT EXPENDITURE_CATEGORY
1806: INTO l_cc_exp_category
1807: FROM pa_expenditure_types WHERE
1808: EXPENDITURE_TYPE = l_prev_exp_type;
1809: EXCEPTION
1810: WHEN NO_DATA_FOUND THEN
1811: l_fi_process_flag_tab(i) := 'N';