1060: BEGIN
1061:
1062: SELECT period1_total_amount
1063: INTO x_total_amount
1064: FROM oe_cust_total_amts
1065: WHERE sold_to_org_id = p_cust_id;
1066:
1067: EXCEPTION
1068: WHEN no_data_found THEN
1143: BEGIN
1144:
1145: SELECT period2_total_amount
1146: INTO x_total_amount
1147: FROM oe_cust_total_amts
1148: WHERE sold_to_org_id = p_cust_id;
1149:
1150: EXCEPTION
1151: WHEN no_data_found THEN
1225: BEGIN
1226:
1227: SELECT period3_total_amount
1228: INTO x_total_amount
1229: FROM oe_cust_total_amts
1230: WHERE sold_to_org_id = p_cust_id;
1231:
1232: EXCEPTION
1233: WHEN no_data_found THEN