APPS.PA_PRJ_PERIOD_PROFILE_UTILS dependencies on PA_AMOUNT_TYPES_B

Line 2254: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE

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

Line 2257: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;

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

Line 2266: FROM pa_amount_types_b atb

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