APPS.PA_PRJ_PERIOD_PROFILE_UTILS dependencies on PA_AMOUNT_TYPES_B

Line 2253: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE

2249: --This function is a local function and is not exposed to other APIs
2250: --This is used to calculate the amount type id based on the amount
2251: --type code passed to it
2252: FUNCTION GET_AMTTYPE_ID
2253: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE
2254: := NULL
2255: ) RETURN NUMBER IS
2256: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
2257: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table;

Line 2256: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;

2252: FUNCTION GET_AMTTYPE_ID
2253: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE
2254: := NULL
2255: ) RETURN NUMBER IS
2256: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
2257: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table;
2258: l_amt_id pa_fp_org_fcst_gen_pub.number_data_type_table;
2259:
2260: l_debug_mode VARCHAR2(30);

Line 2265: FROM pa_amount_types_b atb

2261:
2262: CURSOR get_amt_det IS
2263: SELECT atb.amount_type_id
2264: ,atb.amount_type_code
2265: FROM pa_amount_types_b atb
2266: WHERE atb.amount_type_class = 'R';
2267:
2268: l_stage number := 0;
2269: